[Home] [Help]
96: INSTR(legislative_parameters,' ',
97: INSTR(legislative_parameters,p_token))
98: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token)))
99: ,business_group_id
100: FROM pay_payroll_actions
101: WHERE payroll_action_id = p_pact_id;
102:
103: l_token_value VARCHAR2(50);
104: l_bg_id NUMBER;
435: CURSOR c_process_assignments
436: IS
437: SELECT paf.assignment_id assignment_id
438: FROM per_assignments_f paf
439: ,pay_payroll_actions ppa
440: ,pay_assignment_actions paa
441: WHERE paf.business_group_id = g_bg_id
442: AND paf.person_id BETWEEN p_start_person AND p_end_person
443: AND p_payroll_action_id IS NOT NULL
2662: )
2663: IS
2664: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2665: FROM pay_assignment_actions paa
2666: ,pay_payroll_actions ppa
2667: ,per_assignments_f paf
2668: WHERE paf.assignment_id = paa.assignment_id
2669: AND paf.assignment_id = p_assignment_id
2670: AND paa.tax_unit_id = p_tax_unit_id
2677: AND (1 = DECODE(ppa.action_type,'I',1,0)
2678: OR EXISTS (SELECT ''
2679: FROM pay_action_interlocks intk,
2680: pay_assignment_actions paa1,
2681: pay_payroll_actions ppa1
2682: WHERE intk.locked_action_id = paa.assignment_Action_id
2683: AND intk.locking_action_id = paa1.assignment_action_id
2684: AND paa1.payroll_action_id =ppa1.payroll_action_id
2685: AND paa1.assignment_id = p_assignment_id
2691:
2692: CURSOR c_get_date_earned(l_run_assact NUMBER)
2693: IS
2694: SELECT ppa.date_earned run_date
2695: FROM pay_payroll_actions ppa,
2696: pay_assignment_actions paa
2697: WHERE paa.payroll_action_id = ppa.payroll_action_id
2698: AND paa.assignment_action_id = l_run_assact;
2699:
2699:
2700: CURSOR get_prepayment_date(l_run_assact NUMBER)
2701: IS
2702: SELECT ppa.effective_date
2703: FROM pay_payroll_actions ppa,
2704: pay_assignment_actions paa,
2705: pay_action_interlocks intk
2706: WHERE intk.locked_action_id = l_run_assact
2707: AND intk.locking_action_id =paa.assignment_action_id