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

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

Line 370: -- pa_compiled_multipliers cm

366: -- pa_ind_cost_codes icc,
367: -- pa_cost_base_exp_types cbet,
368: -- pa_ind_rate_schedules_all_bg irs,
369: -- pa_ind_compiled_sets ics,
370: -- pa_compiled_multipliers cm
371: -- WHERE irsr.cost_plus_structure = cbet.cost_plus_structure
372: -- AND cb.cost_base = cbet.cost_base
373: -- AND cb.cost_base_type = 'INDIRECT COST' /*cbet.cost_base_type changed the order */
374: -- AND et.expenditure_type = icc.expenditure_type