DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2119: FROM per_all_assignments_f asgn

2115: BEGIN
2116: UPDATE pa_res_members_temp res_temp
2117: SET res_temp.vendor_id =
2118: (SELECT asgn.vendor_id
2119: FROM per_all_assignments_f asgn
2120: WHERE asgn.person_id = res_temp.person_id
2121: AND asgn.primary_flag = 'Y'
2122: AND asgn.assignment_type = 'C'
2123: AND trunc(sysdate) BETWEEN

Line 2184: FROM per_all_assignments_f assn

2180: IS
2181: BEGIN
2182: UPDATE pa_res_members_temp res_temp
2183: SET job_id = (SELECT job_id
2184: FROM per_all_assignments_f assn
2185: WHERE assn.person_id = res_temp.person_id
2186: AND SYSDATE BETWEEN assn.effective_start_date
2187: AND assn.effective_end_date
2188: AND assn.assignment_type in ('C','E')