DBA Data[Home] [Help]

APPS.PAY_GB_PAYE_SYNC dependencies on PAY_P45_PKG

Line 154: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'

150: AND hsck.segment1 = c_taxref
151: /*AND c_effective_date between pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, c_taxref,c_effective_date)
152: AND pay_gb_eoy_archive.get_agg_active_end(paaf.assignment_id, c_taxref,c_effective_date) */
153: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, c_taxref,c_effective_date) = c_cpe_start_date
154: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
155: group by papf.last_name,
156: paaf.person_id,
157: paaf.assignment_number,
158: paaf.assignment_id,

Line 229: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'

225: AND l_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
226: AND papf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
227: AND hsck.segment1 = l_tax_ref
228: AND paaf.person_id = c_person_id
229: AND pay_p45_pkg.PAYE_SYNC_P45_ISSUED_FLAG(paaf.assignment_id,l_effective_date) = 'N'
230: AND pay_gb_eoy_archive.get_agg_active_start(paaf.assignment_id, l_tax_ref,l_effective_date) <> l_cpe_start_date
231: GROUP BY pay_gb_eoy_archive.get_agg_active_start (paaf.assignment_id, l_tax_ref,l_effective_date),
232: ele.rowid) ppev )
233: GROUP BY cpe_date;