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_BGT_BASELINE_PKG dependencies on PA_AUD_COST_DIST_LINES

Line 788: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

784: -- from pa_expenditure_items_all ei1,
785: -- and ei1.expenditure_item_id = cdl1.expenditure_item_id
786: -- and ei1.system_linkage_function = 'VI'
787: --Bug 3019361
788: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
789: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
790: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
791: and exists (select null
792: from pa_expenditure_items_all ei1,

Line 794: pa_aud_cost_dist_lines aud

790: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
791: and exists (select null
792: from pa_expenditure_items_all ei1,
793: pa_cost_distribution_lines_all cdl1,
794: pa_aud_cost_dist_lines aud
795: --PA.M added outer join to cdl1 and aud plus changed the or to and
796: -- cos if there are no records in aud,
797: -- then this will not pick up the BTC txns
798: where ( cdl1.burden_sum_source_run_id(+) = ei.burden_sum_dest_run_id

Line 902: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids

898: -- from pa_expenditure_items_all ei1,
899: -- and ei1.expenditure_item_id = cdl1.expenditure_item_id
900: -- and ei1.system_linkage_function = 'VI'
901: --Bug 3019361
902: --Added pa_aud_cost_dist_lines to select BTC EIs of previous run ids
903: --During PA.L testing, the below exists clause performed faster than alternative 2 below.
904: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
905: and exists (select null
906: from pa_expenditure_items_all ei1,

Line 908: pa_aud_cost_dist_lines aud

904: --hence replaced pa_bc_commitments join with pa_expenditure_items_all as it was originally
905: and exists (select null
906: from pa_expenditure_items_all ei1,
907: pa_cost_distribution_lines_all cdl1,
908: pa_aud_cost_dist_lines aud
909: --PA.M added outer join to cdl1 and aud plus changed the or to and
910: -- cos if there are no records in aud,
911: -- then this will not pick up the BTC txns
912: where ( cdl1.burden_sum_source_run_id(+) = ei.burden_sum_dest_run_id