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