DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD dependencies on PER_TIME_PERIODS

Line 223: per_time_periods ptp

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
226: AND flex.segment10 IS NOT NULL
227: AND papf.business_group_id = p_business_group_id