APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_ALL_ORGANIZATIONS

Line 407: FROM pa_all_organizations

403: ***********************************************************************/
404: BEGIN
405: SELECT distinct ORGANIZATION_ID
406: INTO x_organization_id
407: FROM pa_all_organizations
408: WHERE INACTIVE_DATE IS NULL
409: AND PA_ORG_USE_TYPE in ('EXPENDITURES', 'PROJECTS')
410: AND ORGANIZATION_ID = l_organization_id;
411: EXCEPTION

Line 2229: pa_all_organizations org

2225: * ***************************************************/
2226: UPDATE pa_res_members_temp res_temp
2227: SET organization_id = (SELECT a.organization_id
2228: FROM per_assignments_x a,
2229: pa_all_organizations org
2230: WHERE a.person_id = res_temp.person_id
2231: AND a.organization_id = org.organization_id
2232: AND org.inactive_date is null
2233: AND org.pa_org_use_type = 'EXPENDITURES'

Line 2284: pa_all_organizations org

2280: BEGIN
2281: SELECT proj.carrying_out_organization_id
2282: INTO l_organization_id
2283: FROM pa_projects_all proj,
2284: pa_all_organizations org
2285: WHERE proj.project_id = p_project_id
2286: AND proj.carrying_out_organization_id = org.organization_id
2287: AND org.inactive_date is null
2288: AND org.pa_org_use_type = 'EXPENDITURES'

Line 7629: pa_all_organizations org,

7625: BEGIN
7626: SELECT a.organization_id, orgvl.name
7627: INTO X_organization_id, X_organization_name
7628: FROM per_assignments_x a,
7629: pa_all_organizations org,
7630: hr_all_organization_units_vl orgvl
7631: WHERE a.person_id = l_person_id
7632: AND a.organization_id = orgvl.organization_id
7633: AND a.organization_id = org.organization_id