DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_ASSIGNMENTS_X

Line 2228: FROM per_assignments_x a,

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

Line 7628: FROM per_assignments_x a,

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