[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
2757: )
2758: IS
2759: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
2760: FROM pay_assignment_actions paa
2761: ,pay_payroll_actions ppa
2762: ,per_assignments_f paf
2763: WHERE paf.assignment_id = paa.assignment_id
2764: AND paf.assignment_id = p_assignment_id
2765: AND paa.tax_unit_id = p_tax_unit_id
2772: AND (1 = DECODE(ppa.action_type,'I',1,0)
2773: OR EXISTS (SELECT ''
2774: FROM pay_action_interlocks intk,
2775: pay_assignment_actions paa1,
2776: pay_payroll_actions ppa1
2777: WHERE intk.locked_action_id = paa.assignment_Action_id
2778: AND intk.locking_action_id = paa1.assignment_action_id
2779: AND paa1.payroll_action_id =ppa1.payroll_action_id
2780: AND paa1.assignment_id = p_assignment_id
2786:
2787: CURSOR c_get_date_earned(l_run_assact NUMBER)
2788: IS
2789: SELECT ppa.date_earned run_date
2790: FROM pay_payroll_actions ppa,
2791: pay_assignment_actions paa
2792: WHERE paa.payroll_action_id = ppa.payroll_action_id
2793: AND paa.assignment_action_id = l_run_assact;
2794:
2794:
2795: CURSOR get_prepayment_date(l_run_assact NUMBER)
2796: IS
2797: SELECT ppa.effective_date
2798: FROM pay_payroll_actions ppa,
2799: pay_assignment_actions paa,
2800: pay_action_interlocks intk
2801: WHERE intk.locked_action_id = l_run_assact
2802: AND intk.locking_action_id =paa.assignment_action_id