APPS.PA_ACCUM_PROJ_LIST dependencies on DUAL

Line 115: FROM dual;

111: CLOSE currperiod_csr;
112:
113: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
114: INTO l_project_accum_id
115: FROM dual;
116:
117: -- Insert Header Record
118:
119: Insert into PA_PROJECT_ACCUM_HEADERS

Line 129: FROM dual

125: l_period_name,
126: 0,0,0,0,G_last_updated_by,Trunc(sysdate),trunc(sysdate),
127: G_request_id,G_created_by,
128: G_last_update_login
129: FROM dual
130: WHERE NOT EXISTS (select 'X'
131: from pa_project_accum_headers
132: where project_id = l_project_id
133: AND task_id = 0

Line 178: FROM dual

174: 0,0,0,
175: 0,0,0,0,
176: 0,NULL,G_request_id,G_last_updated_by,Trunc(sysdate),
177: Trunc(Sysdate),G_created_by,G_last_update_login
178: FROM dual
179: WHERE NOT EXISTS (select 'X'
180: from pa_project_accum_actuals
181: where project_accum_id = l_project_accum_id
182: );

Line 213: FROM dual

209: 0,
210: NULL,G_request_id,G_last_updated_by,Trunc(sysdate),
211: Trunc(Sysdate),G_created_by,
212: G_last_update_login
213: FROM dual
214: WHERE NOT EXISTS (select 'X'
215: from pa_project_accum_commitments
216: where project_accum_id = l_project_accum_id
217: );

Line 264: FROM dual

260: NULL,NULL,
261: 0,0,0,0,0,0,0,0,0,0,
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'

Line 317: FROM dual

313: NULL,NULL,
314: 0,0,0,0,0,0,0,0,0,0,
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'

Line 467: FROM dual;

463: CLOSE currperiod_csr;
464:
465: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
466: INTO l_project_accum_id
467: FROM dual;
468: -- Insert Header Record
469:
470: Insert into PA_PROJECT_ACCUM_HEADERS
471: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,

Line 517: FROM dual

513: 0,0,0,
514: 0,0,0,0,
515: 0,NULL,G_request_id,G_last_updated_by,Trunc(sysdate),
516: Trunc(Sysdate),G_created_by,G_last_update_login
517: FROM dual
518: WHERE NOT EXISTS (select 'X'
519: from pa_project_accum_actuals
520: where project_accum_id = l_project_accum_id
521: );

Line 552: FROM dual

548: 0,
549: NULL,G_request_id,G_last_updated_by,Trunc(sysdate),
550: Trunc(Sysdate),G_created_by,
551: G_last_update_login
552: FROM dual
553: WHERE NOT EXISTS (select 'X'
554: from pa_project_accum_commitments
555: where project_accum_id = l_project_accum_id
556: );

Line 603: FROM dual

599: NULL,NULL,
600: 0,0,0,0,0,0,0,0,0,0,
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'

Line 656: FROM dual

652: NULL,NULL,
653: 0,0,0,0,0,0,0,0,0,0,
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'