DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 576: ,per_assignments_f asg

572: AND action_information3 = g_gre_org_id
573: AND action_context_id IN (SELECT MAX(pai.action_context_id)
574: FROM pay_action_information pai
575: ,pay_assignment_actions paa
576: ,per_assignments_f asg
577: WHERE pai.action_information_category = 'IN_24Q_PERSON'
578: AND pai.action_context_type = 'AAP'
579: AND pai.action_information1 = asg.person_id
580: AND pai.action_information2 = g_assess_year||g_quarter