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_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_RESOURCES_DENORM

Line 553: ,pa_resources_denorm res

549: ,pa_expenditure_items_all ei
550: ,pa_cost_distribution_lines_all cdl
551: ,gl_periods pglp
552: ,pa_work_types_b wt
553: ,pa_resources_denorm res
554: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
555: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
556: -- AND pglp.period_set_name = l_period_set_name
557: AND pglp.period_set_name = l_pa_period_set_name -- bug 3434019

Line 663: ,pa_resources_denorm res

659: ,pa_expenditure_items_all ei
660: ,pa_cost_distribution_lines_all cdl
661: ,gl_periods gglp
662: ,pa_work_types_b wt
663: ,pa_resources_denorm res
664: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
665: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
666: -- AND gglp.period_set_name = l_period_set_name
667: AND gglp.period_set_name = l_gl_period_set_name -- bug 3434019

Line 770: ,pa_resources_denorm res

766: FROM
767: gl_periods pglp
768: ,gl_periods gglp
769: ,pa_work_types_b wt
770: ,pa_resources_denorm res
771: ,pa_expenditures_all exp
772: ,pa_expenditure_items_all ei
773: ,pa_cost_distribution_lines_all cdl
774: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)

Line 890: ,pa_resources_denorm res

886: ,pa_expenditure_items_all ei
887: ,pa_cost_distribution_lines_all cdl
888: ,gl_periods pglp
889: ,pa_work_types_b wt
890: ,pa_resources_denorm res
891: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)
892: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
893: -- AND pglp.period_set_name = l_period_set_name
894: AND pglp.period_set_name = l_pa_period_set_name -- bug 3434019

Line 1000: ,pa_resources_denorm res

996: ,0 prov_wghtd_hrs_people
997: ,'Y' delete_flag
998: FROM
999: pa_work_types_b wt
1000: ,pa_resources_denorm res
1001: ,pa_expenditures_all exp
1002: ,pa_expenditure_items_all ei
1003: ,pa_cost_distribution_lines_all cdl
1004: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)

Line 1113: ,pa_resources_denorm res

1109: FROM
1110: gl_periods pglp
1111: ,gl_periods gglp
1112: ,pa_work_types_b wt
1113: ,pa_resources_denorm res
1114: ,pa_expenditures_all exp
1115: ,pa_expenditure_items_all ei
1116: ,pa_cost_distribution_lines_all cdl
1117: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)

Line 1230: ,pa_resources_denorm res

1226: ,'Y' delete_flag
1227: FROM
1228: gl_periods gglp
1229: ,pa_work_types_b wt
1230: ,pa_resources_denorm res
1231: ,pa_expenditures_all exp
1232: ,pa_expenditure_items_all ei
1233: ,pa_cost_distribution_lines_all cdl
1234: WHERE NVL(cdl.org_id, -99) = NVL(ei.org_id, -99)