DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on PA_PROJECTS_ALL

Line 228: from pa_projects_all ppa,

224: pa_debug.G_err_stage := 'check role based security';
225: -- store project system status code in global variable for instance set
226: IF p_object_name = 'PA_PROJECTS' THEN
227: select project_system_status_code into G_project_system_status_code
228: from pa_projects_all ppa,
229: pa_project_statuses pps
230: where ppa.project_status_code = pps.project_status_code
231: and ppa.project_id = p_object_key;
232: END IF;

Line 918: from pa_projects_all

914: begin
915: x_return_status:=fnd_api.g_ret_sts_success;
916: select CARRYING_OUT_ORGANIZATION_ID
917: into x_project_org_id
918: from pa_projects_all
919: where project_id=p_project_id;
920: exception
921: WHEN NO_DATA_FOUND THEN
922: x_return_status := FND_API.G_RET_STS_ERROR;