APPS.PAY_IN_24QC_ER_RETURNS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 430: FROM pay_assignment_actions paa

426: WHERE action_information_category = 'IN_24QC_DEDUCTEE'
427: AND action_context_type = 'AAP'
428: AND action_information3 = p_gre_org_id
429: AND EXISTS (SELECT 1
430: FROM pay_assignment_actions paa
431: WHERE paa.payroll_action_id = p_max_action_id
432: AND paa.assignment_action_id = pai.action_context_id)
433: AND pai.action_information1 = p_challan;
434:

Line 532: FROM pay_assignment_actions paa

528: AND action_information3 = p_gre_org_id
529: AND action_information1 = p_challan_number
530: AND INSTR(NVL(action_information19,'0'),'C5') = 0
531: AND EXISTS ( SELECT 1
532: FROM pay_assignment_actions paa
533: WHERE paa.payroll_action_id = p_max_action_id
534: AND paa.assignment_action_id = action_context_id));
535:
536: l_proc VARCHAR2(100);

Line 747: ,pay_assignment_actions paa

743: CURSOR csr_get_max_cont_id IS
744: SELECT MAX(pai.action_context_id) action_cont_id
745: ,source_id sour_id
746: FROM pay_action_information pai
747: ,pay_assignment_actions paa
748: ,per_assignments_f asg
749: WHERE paa.payroll_action_id = p_max_action_id
750: AND pai.action_context_id = paa.assignment_action_id
751: AND pai.action_information_category = 'IN_24QC_PERSON'

Line 851: ,pay_assignment_actions paa

847: AND action_information3 = p_gre_org_id
848: AND action_information11 = p_correction_type
849: AND action_context_id IN (SELECT MAX(pai.action_context_id)
850: FROM pay_action_information pai
851: ,pay_assignment_actions paa
852: ,per_assignments_f asg
853: WHERE paa.payroll_action_id = p_max_action_id
854: AND pai.action_context_id = paa.assignment_action_id
855: AND pai.action_information_category = 'IN_24QC_PERSON'