DBA Data[Home] [Help]

APPS.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on GL_PERIODS

Line 551: ,gl_periods pglp

547: FROM
548: pa_expenditures_all exp
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)

Line 661: ,gl_periods gglp

657: FROM
658: pa_expenditures_all exp
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)

Line 767: gl_periods pglp

763: ,0 prov_wghtd_hrs_org
764: ,0 prov_wghtd_hrs_people
765: ,'Y' delete_flag
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

Line 768: ,gl_periods gglp

764: ,0 prov_wghtd_hrs_people
765: ,'Y' delete_flag
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

Line 888: ,gl_periods pglp

884: FROM
885: pa_expenditures_all exp
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)

Line 1110: gl_periods pglp

1106: ,0 prov_wghtd_hrs_org
1107: ,0 prov_wghtd_hrs_people
1108: ,'Y' delete_flag
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

Line 1111: ,gl_periods gglp

1107: ,0 prov_wghtd_hrs_people
1108: ,'Y' delete_flag
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

Line 1228: gl_periods gglp

1224: ,0 prov_wghtd_hrs_org
1225: ,0 prov_wghtd_hrs_people
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