[Home] [Help]
43: INSTR(legislative_parameters,' ',
44: INSTR(legislative_parameters,p_token))
45: - (INSTR(legislative_parameters,p_token)+LENGTH(p_token)))
46: ,business_group_id
47: FROM pay_payroll_actions
48: WHERE payroll_action_id = p_pact_id;
49:
50: l_token_value VARCHAR2(150);
51: l_bg_id NUMBER;
152: ,p_bg_id NUMBER)
153: IS
154: SELECT 1
155: FROM pay_action_information pai
156: ,pay_payroll_actions ppa
157: ,hr_organization_units hou
158: WHERE pai.action_information_category = 'IN_24Q_ORG'
159: AND pai.action_context_type = 'PA'
160: AND pai.action_information1 like g_gre_id
365: CURSOR c_process_assignments
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
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
2471: AND paa.tax_unit_id = p_tax_unit_id
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
2486: AND paa1.assignment_id = p_assignment_id
2493: CURSOR c_get_date_earned(l_run_assact NUMBER)
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: