DBA Data[Home] [Help]

APPS.PA_PLANNING_RESOURCE_UTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2079: FROM per_all_assignments_f asgn

2075: BEGIN
2076: UPDATE pa_res_members_temp res_temp
2077: SET res_temp.vendor_id =
2078: (SELECT asgn.vendor_id
2079: FROM per_all_assignments_f asgn
2080: WHERE asgn.person_id = res_temp.person_id
2081: AND asgn.primary_flag = 'Y'
2082: AND asgn.assignment_type = 'C'
2083: AND trunc(sysdate) BETWEEN

Line 2144: FROM per_all_assignments_f assn

2140: IS
2141: BEGIN
2142: UPDATE pa_res_members_temp res_temp
2143: SET job_id = (SELECT job_id
2144: FROM per_all_assignments_f assn
2145: WHERE assn.person_id = res_temp.person_id
2146: AND SYSDATE BETWEEN assn.effective_start_date
2147: AND assn.effective_end_date
2148: AND assn.assignment_type in ('C','E')