DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_PROJECT_STATUSES

Line 2272: (select PROJECT_STATUS_CODE from pa_project_statuses

2268:
2269: select 'Y' into v_dummy from pa_project_assignments
2270: where assignment_id = v_assig_id
2271: and STATUS_CODE in
2272: (select PROJECT_STATUS_CODE from pa_project_statuses
2273: where PROJECT_SYSTEM_STATUS_CODE = 'OPEN_ASGMT');
2274:
2275: resultout := wf_engine.eng_completed||':'||'S';
2276: