DBA Data[Home] [Help]

APPS.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_WORK_TYPES_B

Line 552: ,pa_work_types_b wt

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)
556: -- AND pglp.period_set_name = l_period_set_name

Line 662: ,pa_work_types_b wt

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)
666: -- AND gglp.period_set_name = l_period_set_name

Line 769: ,pa_work_types_b wt

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
773: ,pa_cost_distribution_lines_all cdl

Line 889: ,pa_work_types_b wt

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)
893: -- AND pglp.period_set_name = l_period_set_name

Line 999: pa_work_types_b wt

995: ,0 prov_wghtd_hrs_org
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

Line 1112: ,pa_work_types_b wt

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
1116: ,pa_cost_distribution_lines_all cdl

Line 1229: ,pa_work_types_b wt

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
1233: ,pa_cost_distribution_lines_all cdl