DBA Data[Home] [Help]

APPS.CREATE_GB_RTI_EPS_RECORD_13 dependencies on HR_SOFT_CODING_KEYFLEX

Line 307: hr_soft_coding_keyflex flex,

303: -- Effective date, Business_group_id, PAYE reference, tax_year_start and Tax_year_end
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