DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 488: FROM pay_assignment_actions paa

484: OR
485: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
486: ))
487: AND EXISTS (SELECT 1
488: FROM pay_assignment_actions paa
489: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
490: AND paa.assignment_action_id = pai.action_context_id)
491: ORDER BY pai.action_information12, TO_NUMBER(action_information25) ASC;
492:

Line 574: ,pay_assignment_actions paa

570: AND action_information3 = g_gre_org_id
571: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
572: AND action_context_id IN (SELECT MAX(pai.action_context_id)
573: FROM pay_action_information pai
574: ,pay_assignment_actions paa
575: ,per_assignments_f asg
576: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
577: AND pai.action_context_id = paa.assignment_action_id
578: AND pai.action_information_category = 'IN_24QC_PERSON'