DBA Data[Home] [Help]

APPS.PA_COPY_CHANGE_DOC_PVT dependencies on PA_PROJECT_STATUSES

Line 504: from pa_project_statuses

500: l_sts_yn varchar2(1) := 'N';
501: cursor c_ci_approved
502: is
503: select 'Y'
504: from pa_project_statuses
505: where status_type='CONTROL_ITEM'
506: and project_system_status_code = 'CI_APPROVED'
507: and project_status_code in (select distinct(status_code)
508: from pa_control_items

Line 672: from pa_project_statuses

668: l_sts_yn varchar2(1) := 'N';
669: cursor c_ci_approved
670: is
671: select 'Y'
672: from pa_project_statuses
673: where status_type='CONTROL_ITEM'
674: and project_system_status_code = 'CI_APPROVED'
675: and project_status_code in (select distinct(status_code)
676: from pa_control_items