APPS.GHR_MTI_APP dependencies on PER_ASSIGNMENTS_F

Line 140: FROM per_assignments_f asg

136: and TRANSFER_TYPE = 'IN';
137:
138: CURSOR c_asg_by_per_id_not_prim (p_per_id number, p_eff_date date) IS
139: SELECT asg.assignment_id
140: FROM per_assignments_f asg
141: WHERE asg.person_id = p_per_id
142: AND asg.assignment_type <> 'B'
143: AND trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
144: ORDER BY asg.assignment_id;