PA Compile All Burden Schedule Revisions

Description
Categories: BI Publisher
Imported from BI Publisher
Description: Compile All Burden Schedule Revisions
Application: Projects
Source: PRC: Compile All Burden Schedule Revisions (XML)
Short Name: PAXCCARS_XML
DB package: PA_PAXCCARS_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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'