DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on PER_ASSIGNMENTS_F

Line 117: per_assignments_f pef,

113: 'SOURCE_TEXT=C', nvl(faidn.context,'To Be Advised')
114: from pay_payroll_actions ppa,
115: hr_soft_coding_keyflex scl,
116: pay_all_payrolls_f papf,
117: per_assignments_f pef,
118: per_people_f ppf,
119: pay_assignment_actions paa,
120: per_assignment_extra_info paei,
121: ff_archive_items fai,

Line 143: from per_assignments_f pef2

139: and ppf.per_information_category = 'ZA'
140: and pef.effective_start_date =
141: (
142: select max(pef2.effective_start_date)
143: from per_assignments_f pef2
144: where pef2.effective_start_date <= ppa.effective_date
145: and pef2.assignment_id = paa.assignment_id
146: )
147: and ppf.effective_start_date =