APPS.PER_FR_BIAF_REPORT dependencies on HR_ASSIGNMENT_SETS

Line 594: hr_assignment_sets hs,

590:
591: cursor c_asg_set1(l_asg_id number,l_bg_id number, p_effective_date date) is
592: select distinct paf.person_id ,l_asg_id ,pef.employee_number
593: from per_all_assignments_f paf,
594: hr_assignment_sets hs,
595: per_all_people_f pef
596: where hs.assignment_set_id=l_asg_id
597: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id
598: and hs.business_group_id=paf.business_group_id

Line 611: hr_assignment_sets hs,

607:
608: cursor c_asg_set2(l_asg_id number,l_bg_id number, p_effective_date date) is
609: select distinct paf.person_id ,l_asg_id ,pef.employee_number
610: from per_all_assignments_f paf,
611: hr_assignment_sets hs,
612: per_all_people_f pef
613: where hs.assignment_set_id=l_asg_id
614: and hs.business_group_id=paf.business_group_id
615: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id

Line 633: from per_all_assignments_f paf,hr_assignment_sets hs,per_all_people_f pef

629:
630: /*
631: UNION
632: select paf.person_id ,l_asg_id ,pef.employee_number
633: from per_all_assignments_f paf,hr_assignment_sets hs,per_all_people_f pef
634: where hs.assignment_set_id=l_asg_id
635: and hs.payroll_id is null
636: and hs.business_group_id=paf.business_group_id
637: and pef.person_id=paf.person_id