APPS.PA_LOOKUPS_PKG dependencies on PA_PROJECTS

Line 297: from pa_projects p

293: into x_dummy
294: from sys.dual
295: where not exists
296: (select 1
297: from pa_projects p
298: where p.project_status_code = x_lookup_code);
299:
300: EXCEPTION
301: WHEN NO_DATA_FOUND then

Line 403: -- PM Product code Pa projects

399: End;
400: Return;
401:
402: elsif (x_stage = 90) then
403: -- PM Product code Pa projects
404: Begin
405: select 1 into x_dummy
406: from sys.dual
407: where not exists

Line 408: (select 1 from pa_projects where pm_product_code

404: Begin
405: select 1 into x_dummy
406: from sys.dual
407: where not exists
408: (select 1 from pa_projects where pm_product_code
409: = x_lookup_code );
410: EXCEPTION
411: WHEN NO_DATA_FOUND then
412: x_return_status := 1;