APPS.BEN_PRC_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 174: from per_all_assignments_f paf

170: abr.effective_start_date and abr.effective_end_date;
171: --
172: cursor c_asg(p_assignment_type varchar2,p_person_id number ) is
173: select paf.assignment_id
174: from per_all_assignments_f paf
175: where paf.person_id = p_person_id
176: and paf.business_group_id = p_business_group_id
177: and paf.primary_flag = 'Y'
178: and paf.assignment_type <> 'C'

Line 1517: from per_all_assignments_f

1513:
1514: cursor c_asg is
1515: select assignment_id
1516: ,payroll_id
1517: from per_all_assignments_f
1518: where person_id = p_submitter_person_id
1519: and assignment_type <> 'C'
1520: and p_effective_Date between
1521: effective_start_date and effective_end_date ;