eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_UTILS dependencies on PA_COMPILED_MULTIPLIERS

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 284: pa_compiled_multipliers cm

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
287: AND cbet.cost_base_type = 'INDIRECT COST'
288: AND cbet.expenditure_type = p_exp_type

Line 305: -- pa_compiled_multipliers cm

301: -- pa_ind_cost_codes icc,
302: -- pa_cost_base_exp_types cbet,
303: -- pa_ind_rate_schedules_all_bg irs,
304: -- pa_ind_compiled_sets ics,
305: -- pa_compiled_multipliers cm
306: -- WHERE irsr.cost_plus_structure = cbet.cost_plus_structure
307: -- AND cb.cost_base = cbet.cost_base
308: -- AND cb.cost_base_type = 'INDIRECT COST' /*cbet.cost_base_type changed the order */
309: -- AND et.expenditure_type = icc.expenditure_type