DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 465: FROM pay_assignment_actions paa

461: OR
462: pay_magtape_generic.get_parameter_value('CORRECTION_TYPE') <> 'C3'
463: ))
464: AND EXISTS (SELECT 1
465: FROM pay_assignment_actions paa
466: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
467: AND paa.assignment_action_id = pai.action_context_id)
468: ORDER BY pai.action_information12, TO_NUMBER(action_information25) ASC;
469:

Line 551: ,pay_assignment_actions paa

547: AND action_information3 = g_gre_org_id
548: AND action_information11=pay_magtape_generic.get_parameter_value('CORRECTION_TYPE')
549: AND action_context_id IN (SELECT MAX(pai.action_context_id)
550: FROM pay_action_information pai
551: ,pay_assignment_actions paa
552: ,per_assignments_f asg
553: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
554: AND pai.action_context_id = paa.assignment_action_id
555: AND pai.action_information_category = 'IN_24QC_PERSON'