DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PAY_ALL_PAYROLLS_F

Line 221: FROM pay_all_payrolls_f papf,

217: (
218: -- Effective date, Business_group_id, PAYE reference, tax_year_start and Tax_year_end
219: -- To fetch all payrolls belonging to this PAYE reference.
220: SELECT DISTINCT papf.payroll_id
221: FROM pay_all_payrolls_f papf,
222: hr_soft_coding_keyflex flex,
223: per_time_periods ptp
224: WHERE papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
225: AND flex.segment1 = p_paye_reference