APPS.PA_DELIVERABLE_PROGRESS_PUB dependencies on PA_PROJECT_STATUSES

Line 522: FROM pa_project_statuses

518: -- Bug 3606627 : AMG Validation
519: IF p_calling_module = 'AMG' THEN
520: BEGIN
521: SELECT 'x' INTO l_dummy
522: FROM pa_project_statuses
523: WHERE status_type = 'DELIVERABLE'
524: AND project_status_code = l_del_status;
525: EXCEPTION
526: WHEN NO_DATA_FOUND THEN

Line 541: FROM pa_project_statuses

537: --l_as_of_date is validated in pa_status_pub
538:
539: BEGIN
540: SELECT 'xyz' INTO l_dummy
541: FROM pa_project_statuses
542: WHERE status_type = 'PROGRESS'
543: AND project_status_code = l_progress_status_code;
544: EXCEPTION
545: WHEN NO_DATA_FOUND THEN

Line 698: FROM pa_project_statuses

694: -- Bug 3606627 : AMG Validation
695: IF p_calling_module = 'AMG' THEN
696: BEGIN
697: SELECT 'x' INTO l_dummy
698: FROM pa_project_statuses
699: WHERE status_type = 'DELIVERABLE'
700: AND project_status_code = l_del_status;
701: EXCEPTION
702: WHEN NO_DATA_FOUND THEN

Line 717: FROM pa_project_statuses

713: --l_as_of_date is validated in pa_status_pub
714:
715: BEGIN
716: SELECT 'xyz' INTO l_dummy
717: FROM pa_project_statuses
718: WHERE status_type = 'PROGRESS'
719: AND project_status_code = l_progress_status_code;
720: EXCEPTION
721: WHEN NO_DATA_FOUND THEN