DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 468: FROM pay_assignment_actions paa

464: AND action_information3 =g_gre_org_id
465: AND action_information1 = pay_magtape_generic.get_parameter_value('BANK_CHALLAN_NO')
466: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'
467: AND EXISTS (SELECT 1
468: FROM pay_assignment_actions paa
469: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('MAX_ACTION_CONTEXT_ID')
470: AND paa.assignment_action_id = pai.action_context_id)
471: ORDER BY pai.action_information2, TO_NUMBER(action_information25) ASC;
472:

Line 575: ,pay_assignment_actions paa

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