DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PER_ASSIGNMENTS_F

Line 607: ,per_assignments_f asg

603: AND action_information3 = g_gre_org_id
604: AND action_context_id IN (SELECT MAX(pai.action_context_id)
605: FROM pay_action_information pai
606: ,pay_assignment_actions paa
607: ,per_assignments_f asg
608: WHERE pai.action_information_category = 'IN_24Q_PERSON'
609: AND pai.action_context_type = 'AAP'
610: AND pai.action_information1 = asg.person_id
611: AND pai.action_information2 = g_assess_year||g_quarter