APPS.GHR_MTI_APP dependencies on PER_ASSIGNMENTS_F

Line 117: FROM per_assignments_f asg

113: and TRANSFER_TYPE = 'IN';
114:
115: CURSOR c_asg_by_per_id_not_prim (p_per_id number, p_eff_date date) IS
116: SELECT asg.assignment_id
117: FROM per_assignments_f asg
118: WHERE asg.person_id = p_per_id
119: AND asg.assignment_type <> 'B'
120: AND trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
121: ORDER BY asg.assignment_id;