APPS.PA_ACCUM_PROJ_LIST dependencies on PA_PROJECT_ACCUM_BUDGETS

Line 14: -- For the pa_project_accum_budgets, one row each is inserted for

10: -- 1) pa_project_accum_headers
11: -- 2) pa_project_accum_actuals
12: -- 3) pa_project_accum_commitments
13: --
14: -- For the pa_project_accum_budgets, one row each is inserted for
15: -- budget_type_codes AC and AR (Approved Cost and Approved Revenue,
16: -- respectively).
17: --
18: -- Rows are only inserted if they do not already exist.

Line 221: Insert into PA_PROJECT_ACCUM_BUDGETS (

217: );
218:
219: -- Approved Cost Budget Record, If NOT Already Exist
220:
221: Insert into PA_PROJECT_ACCUM_BUDGETS (
222: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
223: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
224: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
225: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 266: from pa_project_accum_budgets

262: G_request_id,G_last_updated_by,Trunc(sysdate),
263: Trunc(Sysdate),G_created_by,G_last_update_login
264: FROM dual
265: WHERE NOT EXISTS (select 'X'
266: from pa_project_accum_budgets
267: where project_accum_id = l_project_accum_id
268: and budget_type_code = 'AC'
269: );
270:

Line 274: Insert into PA_PROJECT_ACCUM_BUDGETS (

270:
271:
272: -- Approved Revenue Budget Record, If NOT Already Exist
273:
274: Insert into PA_PROJECT_ACCUM_BUDGETS (
275: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
276: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
277: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
278: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 319: from pa_project_accum_budgets

315: G_request_id,G_last_updated_by,Trunc(sysdate),
316: Trunc(Sysdate),G_created_by,G_last_update_login
317: FROM dual
318: WHERE NOT EXISTS (select 'X'
319: from pa_project_accum_budgets
320: where project_accum_id = l_project_accum_id
321: and budget_type_code = 'AR'
322: );
323:

Line 358: -- For the pa_project_accum_budgets, one row each is inserted for

354: -- 1) pa_project_accum_headers
355: -- 2) pa_project_accum_actuals
356: -- 3) pa_project_accum_commitments
357: --
358: -- For the pa_project_accum_budgets, one row each is inserted for
359: -- budget_type_codes AC and AR (Approved Cost and Approved Revenue,
360: -- respectively).
361: --
362: -- Rows are only inserted if they do not already exist.

Line 560: Insert into PA_PROJECT_ACCUM_BUDGETS (

556: );
557:
558: -- Approved Cost Budget Record, If NOT Already Exist
559:
560: Insert into PA_PROJECT_ACCUM_BUDGETS (
561: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
562: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
563: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
564: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 605: from pa_project_accum_budgets

601: G_request_id,G_last_updated_by,Trunc(sysdate),
602: Trunc(Sysdate),G_created_by,G_last_update_login
603: FROM dual
604: WHERE NOT EXISTS (select 'X'
605: from pa_project_accum_budgets
606: where project_accum_id = l_project_accum_id
607: and budget_type_code = 'AC'
608: );
609:

Line 613: Insert into PA_PROJECT_ACCUM_BUDGETS (

609:
610:
611: -- Approved Revenue Budget Record, If NOT Already Exist
612:
613: Insert into PA_PROJECT_ACCUM_BUDGETS (
614: PROJECT_ACCUM_ID,BUDGET_TYPE_CODE,BASE_RAW_COST_ITD,BASE_RAW_COST_YTD,
615: BASE_RAW_COST_PP, BASE_RAW_COST_PTD,
616: BASE_BURDENED_COST_ITD,BASE_BURDENED_COST_YTD,
617: BASE_BURDENED_COST_PP,BASE_BURDENED_COST_PTD,

Line 658: from pa_project_accum_budgets

654: G_request_id,G_last_updated_by,Trunc(sysdate),
655: Trunc(Sysdate),G_created_by,G_last_update_login
656: FROM dual
657: WHERE NOT EXISTS (select 'X'
658: from pa_project_accum_budgets
659: where project_accum_id = l_project_accum_id
660: and budget_type_code = 'AR'
661: );
662: