APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PROJECT_STATUSES

Line 503: FROM pa_project_statuses

499: -- Bug 3606627 : AMG Validation
500: IF p_calling_module = 'AMG' THEN
501: BEGIN
502: SELECT 'x' INTO l_dummy
503: FROM pa_project_statuses
504: WHERE status_type = 'DELIVERABLE'
505: AND project_status_code = l_del_status;
506: EXCEPTION
507: WHEN NO_DATA_FOUND THEN

Line 522: FROM pa_project_statuses

518: --l_as_of_date is validated in pa_status_pub
519:
520: BEGIN
521: SELECT 'xyz' INTO l_dummy
522: FROM pa_project_statuses
523: WHERE status_type = 'PROGRESS'
524: AND project_status_code = l_progress_status_code;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN

Line 667: FROM pa_project_statuses

663: -- Bug 3606627 : AMG Validation
664: IF p_calling_module = 'AMG' THEN
665: BEGIN
666: SELECT 'x' INTO l_dummy
667: FROM pa_project_statuses
668: WHERE status_type = 'DELIVERABLE'
669: AND project_status_code = l_del_status;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN

Line 686: FROM pa_project_statuses

682: --l_as_of_date is validated in pa_status_pub
683:
684: BEGIN
685: SELECT 'xyz' INTO l_dummy
686: FROM pa_project_statuses
687: WHERE status_type = 'PROGRESS'
688: AND project_status_code = l_progress_status_code;
689: EXCEPTION
690: WHEN NO_DATA_FOUND THEN