APPS.PA_PROJ_ACCUM_MAIN dependencies on DUAL

Line 688: FROM dual

684:
685: BEGIN
686: SELECT 'N'
687: INTO x_ret_flag
688: FROM dual
689: WHERE EXISTS (SELECT 'x'
690: FROM pa_periods
691: WHERE period_name =
692: l_prev_accum_period) ;

Line 707: FROM dual

703:
704: BEGIN
705: SELECT 'N'
706: INTO x_ret_flag
707: FROM dual
708: WHERE EXISTS (SELECT 'x'
709: FROM pa_periods_v
710: WHERE gl_period_name =
711: l_prev_accum_period) ;

Line 1237: FROM dual

1233:
1234: INSERT INTO pa_projects_for_accum
1235: (project_id, request_id, action_flag, segment1, exception_flag)
1236: SELECT recs.project_id, x_request_id, 'CM', recs.segment1, 'N'
1237: FROM dual
1238: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';
1239:
1240: END LOOP;
1241:

Line 2944: FROM sys.dual

2940: x_tasks_restructured_flag := 'N';
2941:
2942: SELECT 'Y'
2943: INTO x_tasks_restructured_flag
2944: FROM sys.dual
2945: WHERE EXISTS (SELECT 'x'
2946: FROM pa_project_accum_headers pah
2947: WHERE pah.project_id = projrec.project_id
2948: AND NVL(pah.tasks_restructured_flag,'N') = 'Y');