APPS.PA_MAINT_PROJECT_ACCUMS dependencies on DUAL

Line 2012: From Dual;

2008:
2009: EXCEPTION
2010: WHEN NO_DATA_FOUND THEN
2011: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2012: From Dual;
2013:
2014: Insert into PA_PROJECT_ACCUM_HEADERS
2015: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2016: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,

Line 2346: From Dual;

2342:
2343: EXCEPTION
2344: WHEN NO_DATA_FOUND THEN
2345: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2346: From Dual;
2347:
2348: Insert into PA_PROJECT_ACCUM_HEADERS
2349: (PROJECT_ACCUM_ID,PROJECT_ID,TASK_ID,ACCUM_PERIOD,RESOURCE_ID,
2350: RESOURCE_LIST_ID,RESOURCE_LIST_ASSIGNMENT_ID,

Line 2803: From Dual;

2799:
2800: If v_noof_tasks > 0 Then
2801: For i in 1..v_noof_tasks LOOP
2802: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2803: From Dual;
2804: Insert_Headers_tasks
2805: (X_project_id,
2806: v_task_array(i),
2807: x_current_period,

Line 2950: From Dual;

2946:
2947: If v_noof_tasks > 0 Then
2948: For i in 1..v_noof_tasks LOOP
2949: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
2950: From Dual;
2951: PA_process_accum_actuals_res.insert_headers_res
2952: (x_project_id,
2953: v_task_array(i),
2954: x_resource_list_id ,

Line 3000: From Dual;

2996: Open Proj_Res_level_Cur;
2997: Fetch Proj_Res_level_Cur Into V_Accum_Id;
2998: IF Proj_Res_level_Cur%NOTFOUND Then
2999: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
3000: From Dual;
3001: PA_process_accum_actuals_res.insert_headers_res
3002: (x_project_id,
3003: 0,
3004: x_resource_list_id ,