APPS.POS_WCAPPROVE_PVT dependencies on PER_ALL_ASSIGNMENTS_F
Line 1226: FROM per_all_people_f person, per_all_assignments_f asg
1222: SELECT person_id, full_name
1223: into l_next_approver_id,l_next_approver_name
1224: FROM (
1225: SELECT person.person_id, person.full_name 1226: FROM per_all_people_f person, per_all_assignments_f asg 1227: WHERE asg.position_id = l_next_approver(1).orig_system_id
1228: and trunc(sysdate) between person.effective_start_date
1229: and nvl(person.effective_end_date, trunc(sysdate))
1230: and person.person_id = asg.person_id