DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 499: FROM pay_assignment_actions paa

495: AND action_information3 =g_gre_org_id
496: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
497: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'
498: AND EXISTS (SELECT 1
499: FROM pay_assignment_actions paa
500: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
501: AND paa.assignment_action_id = pai.action_context_id)
502: ORDER BY pai.action_information2, TO_NUMBER(action_information25) ASC;
503:

Line 606: ,pay_assignment_actions paa

602: AND action_information2 = g_assess_year||g_quarter
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