APPS.PA_PROJ_ACCUM_MAIN dependencies on DUAL

Line 682: FROM dual

678:
679: BEGIN
680: SELECT 'N'
681: INTO x_ret_flag
682: FROM dual
683: WHERE EXISTS (SELECT 'x'
684: FROM pa_periods
685: WHERE period_name =
686: l_prev_accum_period) ;

Line 701: FROM dual

697:
698: BEGIN
699: SELECT 'N'
700: INTO x_ret_flag
701: FROM dual
702: WHERE EXISTS (SELECT 'x'
703: FROM pa_periods_v
704: WHERE gl_period_name =
705: l_prev_accum_period) ;

Line 1194: FROM dual

1190:
1191: INSERT INTO pa_projects_for_accum
1192: (project_id, request_id, action_flag, segment1, exception_flag)
1193: SELECT recs.project_id, x_request_id, 'CM', recs.segment1, 'N'
1194: FROM dual
1195: WHERE Pa_Check_Commitments.commitments_changed(recs.project_id) = 'Y';
1196:
1197: END LOOP;
1198:

Line 2881: FROM sys.dual

2877: x_tasks_restructured_flag := 'N';
2878:
2879: SELECT 'Y'
2880: INTO x_tasks_restructured_flag
2881: FROM sys.dual
2882: WHERE EXISTS (SELECT 'x'
2883: FROM pa_project_accum_headers pah
2884: WHERE pah.project_id = projrec.project_id
2885: AND NVL(pah.tasks_restructured_flag,'N') = 'Y');