DBA Data[Home] [Help]

APPS.PAY_GB_RTI_P60 dependencies on HR_ASSIGNMENT_SETS

Line 3297: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1

3293: AND papf.payroll_id = paaf.payroll_id
3294: AND flex.SOFT_CODING_KEYFLEX_ID = papf.SOFT_CODING_KEYFLEX_ID
3295: AND upper(flex.segment1) = upper(c_tax_ref)
3296: AND (c_asg_set_id IS NULL -- don't check for assignment set in this case
3297: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1
3298: WHERE has1.assignment_set_id = c_asg_set_id
3299: -- AND has1.business_group_id = asg.business_group_id
3300: AND nvl(has1.payroll_id, paaf.payroll_id ) = paaf.payroll_id
3301: AND (NOT EXISTS (SELECT 1 -- chk no amendmts