APPS.PA_SUMMARIZE_ACTUAL_UTIL_PVT dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 298: UPDATE pa_cost_distribution_lines_all

294: PA_DEBUG.g_err_stage := '250 : Before Updating PA_CDL to UTIL_SUMM_FLAG to S';
295: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
296: END IF;
297:
298: UPDATE pa_cost_distribution_lines_all
299: SET util_summarized_flag = 'S'
300: WHERE util_summarized_flag = 'N' AND
301: NVL(org_id,-99) = l_org_id
302: AND ROWID IN (

Line 373: UPDATE pa_cost_distribution_lines_all

369: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
370: END IF;
371:
372: IF l_process_method = 'F' THEN
373: UPDATE pa_cost_distribution_lines_all
374: -- SET util_summarized_flag = 'Y'
375: SET util_summarized_flag = NULL
376: ,request_id = l_request_id
377: ,program_application_id = l_program_application_id

Line 387: UPDATE pa_cost_distribution_lines_all

383: FROM pa_rep_util_summ0_tmp
384: WHERE delete_flag = 'N'
385: );
386: ELSIF l_process_method = 'A' THEN
387: UPDATE pa_cost_distribution_lines_all
388: -- SET util_summarized_flag = 'Y'
389: SET util_summarized_flag = NULL
390: ,request_id = l_request_id
391: ,program_application_id = l_program_application_id

Line 550: ,pa_cost_distribution_lines_all cdl

546: ,'Y' delete_flag
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)

Line 660: ,pa_cost_distribution_lines_all cdl

656: ,'Y' delete_flag
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)

Line 773: ,pa_cost_distribution_lines_all cdl

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)
775: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
776: -- AND pglp.period_set_name = l_period_set_name
777: AND pglp.period_set_name = l_pa_period_set_name -- bug 3434019

Line 887: ,pa_cost_distribution_lines_all cdl

883: ,'Y' delete_flag
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)

Line 1003: ,pa_cost_distribution_lines_all cdl

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)
1005: AND NVL(exp.org_id, -99) = NVL(exp.org_id, -99)
1006: AND ei.expenditure_item_date BETWEEN l_ac_start_date AND TRUNC(l_ac_end_date)+0.99999 /* BUG# 3118592 */
1007: AND ei.expenditure_item_date BETWEEN res.resource_effective_start_date AND NVL(TRUNC(res.resource_effective_end_date)+0.99999, ei.expenditure_item_date) /* BUG# 3118592 */

Line 1116: ,pa_cost_distribution_lines_all cdl

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)
1118: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
1119: -- AND pglp.period_set_name = l_period_set_name
1120: AND pglp.period_set_name = l_pa_period_set_name -- bug 3434019

Line 1233: ,pa_cost_distribution_lines_all cdl

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)
1235: AND NVL(exp.org_id, -99) = NVL(ei.org_id, -99)
1236: -- AND gglp.period_set_name = l_period_set_name
1237: AND gglp.period_set_name = l_gl_period_set_name -- bug 3434019