[Home] [Help]
366: IS
367: SELECT paf.assignment_id assignment_id
368: FROM per_assignments_f paf
369: ,pay_payroll_actions ppa
370: ,pay_assignment_actions paa
371: WHERE paf.business_group_id = g_bg_id
372: AND paf.person_id BETWEEN p_start_person AND p_end_person
373: AND p_payroll_action_id IS NOT NULL
374: AND paa.tax_unit_id LIKE g_gre_id
438: END IF;
439:
440: FOR csr_rec IN c_process_assignments
441: LOOP
442: SELECT pay_assignment_actions_s.NEXTVAL
443: INTO l_action_id
444: FROM dual;
445:
446: if g_debug then
2411: IS
2412: SELECT paa.assignment_id
2413: ,paa.payroll_action_id
2414: ,paf.person_id
2415: FROM pay_assignment_actions paa
2416: ,per_all_assignments_f paf
2417: WHERE paa.assignment_action_id = p_assignment_action_id
2418: AND paa.assignment_id = paf.assignment_id
2419: AND ROWNUM =1;
2437: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
2438: ,scl.segment1
2439: FROM per_assignments_f asg
2440: ,hr_soft_coding_keyflex scl
2441: ,pay_assignment_actions paa
2442: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2443: AND paa.assignment_action_id = p_assignment_action_id
2444: AND asg.assignment_id = paa.assignment_id
2445: AND scl.segment1 LIKE g_gre_id
2462: ,p_assignment_id NUMBER
2463: )
2464: IS
2465: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2466: FROM pay_assignment_actions paa
2467: ,pay_payroll_actions ppa
2468: ,per_assignments_f paf
2469: WHERE paf.assignment_id = paa.assignment_id
2470: AND paf.assignment_id = p_assignment_id
2477: AND paa.source_action_id IS NULL
2478: AND (1 = DECODE(ppa.action_type,'I',1,0)
2479: OR EXISTS (SELECT ''
2480: FROM pay_action_interlocks intk,
2481: pay_assignment_actions paa1,
2482: pay_payroll_actions ppa1
2483: WHERE intk.locked_action_id = paa.assignment_Action_id
2484: AND intk.locking_action_id = paa1.assignment_action_id
2485: AND paa1.payroll_action_id =ppa1.payroll_action_id
2494: IS
2495: SELECT ppa.date_earned run_date
2496: ,ppa.payroll_id
2497: FROM pay_payroll_actions ppa,
2498: pay_assignment_actions paa
2499: WHERE paa.payroll_action_id = ppa.payroll_action_id
2500: AND paa.assignment_action_id = l_run_assact;
2501:
2502: CURSOR c_pay_action_level_check(p_payroll_action_id NUMBER
2503: ,p_gre_id NUMBER)
2504: IS
2505: SELECT 1
2506: FROM pay_action_information pai,
2507: pay_assignment_actions paa
2508: WHERE pai.action_information_category = 'IN_24Q_ORG'
2509: AND pai.action_context_type = 'PA'
2510: AND pai.action_context_id = p_payroll_action_id
2511: AND pai.action_information1 = p_gre_id
2763: FROM pay_action_information
2764: WHERE action_information_category = 'IN_24Q_DEDUCTEE'
2765: AND action_context_type = 'AAP'
2766: AND action_context_id IN (SELECT assignment_action_id
2767: FROM pay_assignment_actions
2768: WHERE payroll_action_id = p_payroll_action_id)
2769: ORDER BY action_information3;
2770:
2771:
2780: AND action_context_type = 'AAP'
2781: AND action_information3 = p_gre_id
2782: AND action_information1 = p_challan
2783: AND action_context_id IN (SELECT assignment_action_id
2784: FROM pay_assignment_actions
2785: WHERE payroll_action_id = p_payroll_action_id)
2786: ORDER BY action_information2
2787: , action_information4;
2788:
2793: FROM pay_action_information
2794: WHERE action_information_category = 'IN_24Q_PERSON'
2795: AND action_context_type = 'AAP'
2796: AND action_context_id IN (SELECT assignment_action_id
2797: FROM pay_assignment_actions
2798: WHERE payroll_action_id = p_payroll_action_id)
2799: ORDER BY action_information3;
2800:
2801:
2809: WHERE action_information_category = 'IN_24Q_PERSON'
2810: AND action_context_type = 'AAP'
2811: AND action_information3 = p_gre_id
2812: AND action_context_id IN (SELECT assignment_action_id
2813: FROM pay_assignment_actions
2814: WHERE payroll_action_id = p_payroll_action_id)
2815: ORDER BY LENGTH(action_information1)
2816: ,action_information1
2817: ,source_id;