PA Compile All Burden Schedule Revisions

Description
Categories: BI Publisher
Columns: Ind Rate Sch Name1, Ind Rate Sch Revision1, Meaning1 ...
Application: Projects
Source: PRC: Compile All Burden Schedule Revisions (XML)
Short Name: PAXCCARS_XML
DB package: PA_PAXCCARS_XMLP_PKG
select irs.ind_rate_sch_name IND_RATE_SCH_NAME1, 
		 irsr.ind_rate_sch_revision IND_RATE_SCH_REVISION1,
           lu.meaning MEANING1
from pa_ind_rate_sch_revisions irsr, 
         pa_ind_rate_schedules irs,
         pa_lookups lu
where irsr.compiled_flag = 'Y'
and     irsr.request_id = :P_CONC_REQUEST_ID
and     irsr.ind_rate_sch_id = irs.ind_rate_sch_id
and     irsr.ind_rate_sch_revision_type = lu.lookup_code
and     lu.lookup_type = 'IND RATE SCHEDULE REV TYPE'
Parameter Name SQL text Validation
Debug Mode