DBA Data[Home] [Help]

APPS.PAY_GB_WNU_RULES dependencies on PAY_ALL_PAYROLLS_F

Line 221: pay_all_payrolls_f papf,

217: cursor csr_agg_assignment is
218: select min(aaf.assignment_id) assignment_id
219: from per_all_assignments_f aaf,
220: hr_soft_coding_keyflex hsck,
221: pay_all_payrolls_f papf,
222: per_assignment_status_types past
223: where aaf.person_id = p_person_id
224: AND p_effective_date between
225: aaf.effective_start_date and aaf.effective_end_date

Line 235: pay_all_payrolls_f papf2,

231: AND p_effective_date BETWEEN aaf.effective_start_date AND aaf.effective_end_date
232: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
233: AND hsck.segment1 in ( SELECT distinct(hsck.segment1)
234: FROM hr_soft_coding_keyflex hsck2,
235: pay_all_payrolls_f papf2,
236: per_all_assignments_f paaf,
237: per_assignment_status_types past2
238: WHERE hsck2.soft_coding_keyflex_id = papf2.soft_coding_keyflex_id
239: AND papf2.payroll_id =paaf.payroll_id