APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_IND_RATE_SCH_REVISIONS

Line 253: pa_compiled_multipliers to pa_ind_rate_sch_revisions is causing FTS

249: (g_exp_org_id is NULL or p_exp_org_id <> g_exp_org_id) OR
250: (g_exp_type is NULL or g_exp_type <> p_exp_type ) THEN
251:
252: /* bug fix: 2795051 Performance Issues driving the table from
253: pa_compiled_multipliers to pa_ind_rate_sch_revisions is causing FTS
254: on pa_ind_rate_sch_revisions. Refer to the above bug for Explain plan and other details
255: */
256:
257: l_sch_rev_id := get_fc_compiled_set_id

Line 254: on pa_ind_rate_sch_revisions. Refer to the above bug for Explain plan and other details

250: (g_exp_type is NULL or g_exp_type <> p_exp_type ) THEN
251:
252: /* bug fix: 2795051 Performance Issues driving the table from
253: pa_compiled_multipliers to pa_ind_rate_sch_revisions is causing FTS
254: on pa_ind_rate_sch_revisions. Refer to the above bug for Explain plan and other details
255: */
256:
257: l_sch_rev_id := get_fc_compiled_set_id
258: ( p_task_id => p_task_id

Line 282: FROM pa_ind_rate_sch_revisions irsr,

278: If l_sch_rev_id is NOT NULL and l_compile_set_id is NOT NULL Then
279:
280: SELECT SUM(NVL(cm.compiled_multiplier,0))
281: INTO l_multiplier
282: FROM pa_ind_rate_sch_revisions irsr,
283: pa_cost_base_exp_types cbet,
284: pa_compiled_multipliers cm
285: WHERE irsr.ind_rate_sch_revision_id = l_sch_rev_id
286: AND cbet.cost_plus_structure = irsr.cost_plus_structure

Line 298: -- pa_ind_rate_sch_revisions irsr,

294:
295: -- SELECT SUM(cm.compiled_multiplier)
296: -- INTO l_multiplier
297: -- FROM
298: -- pa_ind_rate_sch_revisions irsr,
299: -- pa_cost_bases cb,
300: -- pa_expenditure_types et,
301: -- pa_ind_cost_codes icc,
302: -- pa_cost_base_exp_types cbet,