APPS.OTA_INITIALIZATION_WF dependencies on PER_ALL_ASSIGNMENTS_F

Line 1358: FROM per_all_assignments_f asg,

1354: AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date;
1355: -- get supervisor name
1356: CURSOR csr_supervisor_id IS
1357: SELECT asg.supervisor_id, per.full_name
1358: FROM per_all_assignments_f asg,
1359: per_all_people_f per
1360: WHERE asg.person_id = p_person_id
1361: AND per.person_id = asg.supervisor_id
1362: AND asg.primary_flag = 'Y'