[Home] [Help]
365: IS
366: SELECT paf.assignment_id assignment_id
367: FROM per_assignments_f paf
368: ,pay_payroll_actions ppa
369: ,pay_assignment_actions paa
370: WHERE paf.business_group_id = g_bg_id
371: AND paf.person_id BETWEEN p_start_person AND p_end_person
372: AND p_payroll_action_id IS NOT NULL
373: AND paa.tax_unit_id LIKE g_gre_id
456: END IF;
457:
458: FOR csr_rec IN c_process_assignments
459: LOOP
460: SELECT pay_assignment_actions_s.NEXTVAL
461: INTO l_action_id
462: FROM dual;
463:
464: if g_debug then
2517: IS
2518: SELECT paa.assignment_id
2519: ,paa.payroll_action_id
2520: ,paf.person_id
2521: FROM pay_assignment_actions paa
2522: ,per_all_assignments_f paf
2523: WHERE paa.assignment_action_id = p_assignment_action_id
2524: AND paa.assignment_id = paf.assignment_id
2525: AND ROWNUM =1;
2543: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
2544: ,scl.segment1
2545: FROM per_assignments_f asg
2546: ,hr_soft_coding_keyflex scl
2547: ,pay_assignment_actions paa
2548: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2549: AND paa.assignment_action_id = p_assignment_action_id
2550: AND asg.assignment_id = paa.assignment_id
2551: AND scl.segment1 LIKE g_gre_id
2568: ,p_assignment_id NUMBER
2569: )
2570: IS
2571: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2572: FROM pay_assignment_actions paa
2573: ,pay_payroll_actions ppa
2574: ,per_assignments_f paf
2575: WHERE paf.assignment_id = paa.assignment_id
2576: AND paf.assignment_id = p_assignment_id
2583: AND paa.source_action_id IS NULL
2584: AND (1 = DECODE(ppa.action_type,'I',1,0)
2585: OR EXISTS (SELECT ''
2586: FROM pay_action_interlocks intk,
2587: pay_assignment_actions paa1,
2588: pay_payroll_actions ppa1
2589: WHERE intk.locked_action_id = paa.assignment_Action_id
2590: AND intk.locking_action_id = paa1.assignment_action_id
2591: AND paa1.payroll_action_id =ppa1.payroll_action_id
2600: IS
2601: SELECT ppa.date_earned run_date
2602: ,ppa.payroll_id
2603: FROM pay_payroll_actions ppa,
2604: pay_assignment_actions paa
2605: WHERE paa.payroll_action_id = ppa.payroll_action_id
2606: AND paa.assignment_action_id = l_run_assact;
2607:
2608: CURSOR c_pay_action_level_check(p_payroll_action_id NUMBER
2609: ,p_gre_id NUMBER)
2610: IS
2611: SELECT 1
2612: FROM pay_action_information pai,
2613: pay_assignment_actions paa
2614: WHERE pai.action_information_category = 'IN_24Q_ORG'
2615: AND pai.action_context_type = 'PA'
2616: AND pai.action_context_id = p_payroll_action_id
2617: AND pai.action_information1 = p_gre_id
2869: FROM pay_action_information
2870: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
2871: AND action_context_type = 'AAP'
2872: AND action_context_id IN (SELECT assignment_action_id
2873: FROM pay_assignment_actions
2874: WHERE payroll_action_id = p_payroll_action_id)
2875: ORDER BY action_information3;
2876:
2877:
2886: AND action_context_type = 'AAP'
2887: AND action_information3 = p_gre_id
2888: AND action_information1 = p_challan
2889: AND action_context_id IN (SELECT assignment_action_id
2890: FROM pay_assignment_actions
2891: WHERE payroll_action_id = p_payroll_action_id)
2892: ORDER BY action_information2
2893: , action_information4;
2894:
2899: FROM pay_action_information
2900: WHERE action_information_category = 'IN_24Q_PERSON'
2901: AND action_context_type = 'AAP'
2902: AND action_context_id IN (SELECT assignment_action_id
2903: FROM pay_assignment_actions
2904: WHERE payroll_action_id = p_payroll_action_id)
2905: ORDER BY action_information3;
2906:
2907:
2915: WHERE action_information_category = 'IN_24Q_PERSON'
2916: AND action_context_type = 'AAP'
2917: AND action_information3 = p_gre_id
2918: AND action_context_id IN (SELECT assignment_action_id
2919: FROM pay_assignment_actions
2920: WHERE payroll_action_id = p_payroll_action_id)
2921: ORDER BY LENGTH(action_information1)
2922: ,action_information1
2923: ,source_id;