DBA Data[Home] [Help]

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_PROJECT_STATUSES

Line 2273: (select PROJECT_STATUS_CODE from pa_project_statuses

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