APPS.PA_CAPITALIZED_INTEREST dependencies on PA_IND_COST_MULTIPLIERS

Line 88: -- the pa_ind_cost_multipliers.ready_to_compile_flag is marked with X but not

84: delete pa_cint_rate_multipliers
85: where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id;
86:
87: -- When deleted the records from multipliers in the Burden Schedules form,
88: -- the pa_ind_cost_multipliers.ready_to_compile_flag is marked with X but not
89: -- actually deleted. So, deleting those marked with X during compilation process.
90:
91: delete pa_ind_cost_multipliers
92: where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id

Line 91: delete pa_ind_cost_multipliers

87: -- When deleted the records from multipliers in the Burden Schedules form,
88: -- the pa_ind_cost_multipliers.ready_to_compile_flag is marked with X but not
89: -- actually deleted. So, deleting those marked with X during compilation process.
90:
91: delete pa_ind_cost_multipliers
92: where ind_rate_sch_revision_id = l_ind_rate_sch_rev_id
93: and ready_to_compile_flag = 'X';
94:
95: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 284: from pa_ind_cost_multipliers cm

280: l_request_id,
281: l_program_application_id,
282: l_program_id,
283: SYSDATE
284: from pa_ind_cost_multipliers cm
285: where cm.ind_rate_sch_revision_id = p_rate_sch_rev_id
286: and cm.organization_id = p_current_org_id
287: UNION ALL
288: SELECT p_rate_sch_rev_id,

Line 306: from pa_ind_cost_multipliers cm1

302: from pa_cint_rate_multipliers icm
303: where icm.ind_rate_sch_revision_id = p_rate_sch_rev_id
304: and icm.organization_id = p_org_id_parent
305: and icm.rate_name not in (select cm1.ind_cost_code
306: from pa_ind_cost_multipliers cm1
307: where cm1.ind_rate_sch_revision_id = p_rate_sch_rev_id
308: and cm1.organization_id = p_current_org_id);
309:
310: EXCEPTION