APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_ASSIGNMENTS_X

Line 2268: FROM per_assignments_x a,

2264: * based on person's HR 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

Line 7786: FROM per_assignments_x a,

7782: -- Get the person's HR Org and pass back
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