APPS.PA_PURGE_VALIDATE_PJRM dependencies on DUAL

Line 49: from dual

45: --
46: cursor IsAPJRMProject is
47:
48: select 'Assignment or Requirement Exists' , 'PA_ARPR_ASG_REQ_EXISTS'
49: from dual
50: where exists ( select NULL
51: from pa_project_assignments pa
52: where nvl(pa.project_id, 0) = p_project_id
53: )

Line 56: from dual

52: where nvl(pa.project_id, 0) = p_project_id
53: )
54: UNION
55: select 'Administrative or Unassigned Time Type' , 'PA_ARPR_ADM_UNASS_PRJ_TYP'
56: from dual
57: where exists ( select pt.project_type
58: from pa_project_types_all pt,
59: pa_projects_all p
60: where p.project_id = p_project_id

Line 402: FROM DUAL

398: l_err_code NUMBER ;
399:
400: CURSOR chk_funding IS
401: SELECT 1
402: FROM DUAL
403: WHERE EXISTS
404: (SELECT NULL
405: FROM pa_project_fundings
406: WHERE project_id = p_project_id

Line 411: FROM DUAL

407: AND pji_summarized_flag = 'N');
408:
409: CURSOR chk_revenue IS
410: SELECT 1
411: FROM DUAL
412: WHERE EXISTS
413: (SELECT NULL
414: FROM pa_draft_revenues_all
415: WHERE project_id = p_project_id

Line 422: FROM DUAL

418: AND pji_summarized_flag = 'N');
419:
420: CURSOR chk_cdl IS
421: SELECT 1
422: FROM DUAL
423: WHERE EXISTS
424: (SELECT NULL
425: FROM pa_cost_distribution_lines_all
426: WHERE project_id = p_project_id

Line 432: FROM DUAL

428: AND pji_summarized_flag = 'N');
429:
430: CURSOR chk_inv IS
431: SELECT 1
432: FROM DUAL
433: WHERE EXISTS
434: (SELECT NULL
435: FROM pa_draft_invoices_all
436: WHERE project_id = p_project_id

Line 443: FROM DUAL

439: AND pji_summarized_flag = 'N');
440:
441: CURSOR chk_log IS
442: SELECT 1
443: FROM DUAL
444: WHERE EXISTS
445: (SELECT NULL
446: FROM pa_pji_proj_events_log
447: WHERE event_type in ('Projects', 'Classifications', 'DRAFT_REVENUES')

Line 474: l_string := 'SELECT PJI_UTILS.GET_EXTRACTION_START_DATE FROM DUAL'; /* Modified for bug 12979524 */

470: RETURN;
471: END IF;
472:
473: IF l_count > 1 THEN
474: l_string := 'SELECT PJI_UTILS.GET_EXTRACTION_START_DATE FROM DUAL'; /* Modified for bug 12979524 */
475: EXECUTE IMMEDIATE l_string INTO l_start_date;
476:
477: SELECT project_status_code
478: INTO l_project_status

Line 531: SELECT 1 from dual

527: x_err_code IN OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
528: x_err_stack IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
529: x_err_stage IN OUT NOCOPY VARCHAR2 ) IS --File.Sql.39 bug 4440895
530: cursor chk_pji_migrated IS
531: SELECT 1 from dual
532: where exists (select 1
533: from pa_projects_all
534: where project_id=p_project_id
535: and pji_source_flag='Y');