DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on PER_TIME_PERIODS

Line 308: per_time_periods ptp

304: -- To fetch all payrolls belonging to this PAYE reference.
305: SELECT DISTINCT papf.payroll_id
306: FROM pay_all_payrolls_f papf,
307: hr_soft_coding_keyflex flex,
308: per_time_periods ptp
309: WHERE papf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
310: AND flex.segment1 = p_paye_reference
311: AND flex.segment10 IS NOT NULL
312: AND papf.business_group_id = p_business_group_id