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: