DBA Data[Home] [Help]

APPS.PAY_IE_HIST_ARCH_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 82: per_all_assignments_f paaf

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

Line 121: from per_all_assignments_f paaf,

117: cp_end_date varchar2 ) is
118: select distinct paa.assignment_action_id,
119: paaf.assignment_id,
120: ppa.effective_date
121: from per_all_assignments_f paaf,
122: pay_payroll_actions ppa,
123: pay_assignment_actions paa,
124: pay_action_interlocks lck,
125: pay_payroll_actions ppa1,