APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PA_ALL_ORGANIZATIONS

Line 411: FROM pa_all_organizations

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

Line 2269: pa_all_organizations org

2265: * ***************************************************/
2266: UPDATE pa_res_members_temp res_temp
2267: SET organization_id = (SELECT a.organization_id
2268: FROM per_assignments_x a,
2269: pa_all_organizations org
2270: WHERE a.person_id = res_temp.person_id
2271: AND a.organization_id = org.organization_id
2272: AND org.inactive_date is null
2273: AND org.pa_org_use_type = 'EXPENDITURES'

Line 2324: pa_all_organizations org

2320: BEGIN
2321: SELECT proj.carrying_out_organization_id
2322: INTO l_organization_id
2323: FROM pa_projects_all proj,
2324: pa_all_organizations org
2325: WHERE proj.project_id = p_project_id
2326: AND proj.carrying_out_organization_id = org.organization_id
2327: AND org.inactive_date is null
2328: AND org.pa_org_use_type = 'EXPENDITURES'

Line 7787: pa_all_organizations org,

7783: BEGIN
7784: SELECT a.organization_id, orgvl.name
7785: INTO X_organization_id, X_organization_name
7786: FROM per_assignments_x a,
7787: pa_all_organizations org,
7788: hr_all_organization_units_vl orgvl
7789: WHERE a.person_id = l_person_id
7790: AND a.organization_id = orgvl.organization_id
7791: AND a.organization_id = org.organization_id