APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_IND_RATE_SCH_REVISIONS

Line 309: pa_compiled_multipliers to pa_ind_rate_sch_revisions is causing FTS

305: (g_exp_org_id is NULL or p_exp_org_id <> g_exp_org_id) OR
306: (g_exp_type is NULL or g_exp_type <> p_exp_type ) THEN
307:
308: /* bug fix: 2795051 Performance Issues driving the table from
309: pa_compiled_multipliers to pa_ind_rate_sch_revisions is causing FTS
310: on pa_ind_rate_sch_revisions. Refer to the above bug for Explain plan and other details
311: */
312:
313: l_sch_rev_id := get_fc_compiled_set_id

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

306: (g_exp_type is NULL or g_exp_type <> p_exp_type ) THEN
307:
308: /* bug fix: 2795051 Performance Issues driving the table from
309: pa_compiled_multipliers to pa_ind_rate_sch_revisions is causing FTS
310: on pa_ind_rate_sch_revisions. Refer to the above bug for Explain plan and other details
311: */
312:
313: l_sch_rev_id := get_fc_compiled_set_id
314: ( p_task_id => p_task_id

Line 343: FROM pa_ind_rate_sch_revisions irsr,

339: If l_sch_rev_id is NOT NULL and l_compile_set_id is NOT NULL Then
340:
341: SELECT SUM(NVL(cm.compiled_multiplier,0))
342: INTO l_multiplier
343: FROM pa_ind_rate_sch_revisions irsr,
344: pa_cost_base_exp_types cbet,
345: pa_compiled_multipliers cm
346: WHERE irsr.ind_rate_sch_revision_id = l_sch_rev_id
347: AND cbet.cost_plus_structure = irsr.cost_plus_structure

Line 363: -- pa_ind_rate_sch_revisions irsr,

359:
360: -- SELECT SUM(cm.compiled_multiplier)
361: -- INTO l_multiplier
362: -- FROM
363: -- pa_ind_rate_sch_revisions irsr,
364: -- pa_cost_bases cb,
365: -- pa_expenditure_types et,
366: -- pa_ind_cost_codes icc,
367: -- pa_cost_base_exp_types cbet,