DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 1082: FROM per_all_assignments_f

1078: WHERE resource_id = l_resource_id;
1079:
1080: CURSOR c_asg(p_person_id IN NUMBER) IS
1081: SELECT job_id
1082: FROM per_all_assignments_f
1083: WHERE person_id = p_source_id
1084: AND primary_flag = 'Y'
1085: AND assignment_type in ('E','C')
1086: AND trunc(sysdate) between effective_start_date and effective_end_date;