DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on PA_PROJECTS_ALL

Line 218: from pa_projects_all ppa,

214: pa_debug.G_err_stage := 'check role based security';
215: -- store project system status code in global variable for instance set
216: IF p_object_name = 'PA_PROJECTS' THEN
217: select project_system_status_code into G_project_system_status_code
218: from pa_projects_all ppa,
219: pa_project_statuses pps
220: where ppa.project_status_code = pps.project_status_code
221: and ppa.project_id = p_object_key;
222: END IF;

Line 907: from pa_projects_all

903: begin
904: x_return_status:=fnd_api.g_ret_sts_success;
905: select CARRYING_OUT_ORGANIZATION_ID
906: into x_project_org_id
907: from pa_projects_all
908: where project_id=p_project_id;
909: exception
910: WHEN NO_DATA_FOUND THEN
911: x_return_status := FND_API.G_RET_STS_ERROR;