APPS.PAY_SA_HIST_ARCH_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 85: per_all_assignments_f paaf

81: hr_utility.trace('Range Cursor using Payroll Restriction');
82: sqlstr := 'SELECT DISTINCT ppf.person_id
83: FROM per_all_people_f ppf,
84: pay_payroll_actions ppa,
85: per_all_assignments_f paaf
86: WHERE ppa.payroll_action_id = :payroll_action_id
87: AND ppf.business_group_id +0 = ppa.business_group_id
88: AND paaf.person_id = ppf.person_id
89: AND paaf.payroll_id = '|| to_char(l_payroll_id)||

Line 126: from per_all_assignments_f paaf,

122:
123: select distinct paa.assignment_action_id,
124: paaf.assignment_id,
125: ppa.effective_date
126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,