DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_IND_RATE_SCH_REVISIONS

Line 241: FROM pa_ind_rate_sch_revisions irs

237: IF x_burden_sch_id is NOT NULL Then
238: Begin
239: SELECT irs.ind_rate_sch_revision_id
240: INTO x_burden_sch_revision_id
241: FROM pa_ind_rate_sch_revisions irs
242: WHERE irs.ind_rate_sch_id = x_burden_sch_id
243: AND irs.compiled_flag = 'Y'
244: AND trunc(p_exp_item_date) BETWEEN irs.start_date_active
245: and NVL(irs.end_date_active ,p_exp_item_date );