APPS.PA_TXN_ACCUMS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 166: -- UPDATE pa_cost_distribution_lines_all statement:

162:
163:
164: --
165: -- 20-MAY-2003 jwhite For r11i.PA.L Burdening Enhancements, modified the
166: -- UPDATE pa_cost_distribution_lines_all statement:
167: --
168: -- Code like the following:
169: -- AND cdl.line_type = 'R'
170: -- was replaced with the following:

Line 197: UPDATE pa_cost_distribution_lines_all SET

193: tot_recs_processed := 0;
194:
195: LOOP
196:
197: UPDATE pa_cost_distribution_lines_all SET
198: resource_accumulated_flag = 'N'
199: WHERE project_id = x_start_project_id AND
200: (line_type = 'R' OR line_type = 'I') AND
201: resource_accumulated_flag <> 'N' AND

Line 2714: pa_cost_distribution_lines_all cdl

2710: FROM
2711: pa_expenditures_all pe,
2712: pa_expenditure_types et,
2713: pa_expenditure_items_all ei,
2714: pa_cost_distribution_lines_all cdl
2715: WHERE
2716: cdl.project_id = x_start_project_id -- BETWEEN x_start_project_id AND x_end_project_id
2717: AND cdl.line_type = x_cdl_line_type
2718: AND cdl.resource_accumulated_flag = 'N'

Line 2763: pa_cost_distribution_lines_all cdl

2759: FROM
2760: pa_expenditures_all pe,
2761: pa_expenditure_types et,
2762: pa_expenditure_items_all ei,
2763: pa_cost_distribution_lines_all cdl
2764: WHERE
2765: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097
2766: cdl.project_id = x_start_project_id
2767: AND cdl.line_type = x_cdl_line_type

Line 2794: pa_cost_distribution_lines_all cdl,

2790: gl_date_period_map g,
2791: pa_expenditures_all pe,
2792: pa_expenditure_types et,
2793: pa_expenditure_items_all ei,
2794: pa_cost_distribution_lines_all cdl,
2795: pa_implementations pi,
2796: gl_sets_of_books sob
2797: WHERE
2798: -- cdl.project_id BETWEEN x_start_project_id AND x_end_project_id -- Modified for bug 3736097

Line 2934: pa_cost_distribution_lines_all

2930:
2931: --- Update the CDL.Resource_accumulated_flag = 'Y' Now
2932:
2933: UPDATE
2934: pa_cost_distribution_lines_all
2935: SET
2936: resource_accumulated_flag = 'Y'
2937: WHERE
2938: ROWID = cdlrec.cdlrowid;