[Home] [Help]
276: IS
277: SELECT distinct pjiav.assignment_id, pjiav.effective_date
278: FROM per_all_assignments_f paa,
279: per_all_people_f pap,
280: pay_assignment_actions pas,
281: pay_jp_isdf_assact_v pjiav
282: WHERE paa.person_id between p_start_person_id and p_end_person_id
283: AND paa.person_id = pap.person_id
284: AND sysdate between pap.effective_start_date and pap.effective_end_date
293: or pjiav.transaction_status = decode(trans_stat,'Y','F')
294: or pjiav.transaction_status = decode(trans_stat,'Y','N')
295: or pjiav.transaction_status = decode(trans_stat,'Y','U')); -- Last condition in where clause added for Bug Fix:5487428
296: --
297: l_assact pay_assignment_actions.assignment_action_id%type ;
298: l_proc_name VARCHAR2(60);
299: l_old_pact_id NUMBER;
300: l_cur_pact NUMBER;
301: l_legislative_parameters VARCHAR2(2000);
344: FOR i IN c_assact(l_old_pact_id,l_prn_app_opt) LOOP
345: -- Added NVL to overcome NULL issue.
346: IF (NVL(l_ass_set_id,0) = 0) THEN
347: -- NO assignment set passed as parameter
348: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
349: hr_nonrun_asact.insact(l_assact,
350: i.assignment_id ,
351: p_payroll_action_id,
352: p_chunk,
362: IF (g_all_exclusions_flag = 0) THEN
363: -- assignment set by ammmendment passed is not all exclusions.
364: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
365: IF (l_result1 = 'I') THEN
366: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
367: hr_nonrun_asact.insact(l_assact,
368: i.assignment_id ,
369: p_payroll_action_id,
370: p_chunk,
374: ELSE
375: -- assignment set by ammmendment passed is all exclusions.
376: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
377: IF (l_result1 <> 'E') THEN
378: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
379: hr_nonrun_asact.insact(l_assact,
380: i.assignment_id ,
381: p_payroll_action_id,
382: p_chunk,
388: ELSE
389: -- assignment set by criteria passed
390: l_result2 := chk_ass_set(i.assignment_id, l_ass_set_id, l_formula_id, i.effective_date, g_dummy);
391: IF (l_result2 = TRUE) THEN
392: SELECT pay_assignment_actions_s.nextval into l_assact from dual;
393: hr_nonrun_asact.insact(l_assact,
394: i.assignment_id ,
395: p_payroll_action_id,
396: p_chunk,
443: pjip.tax_office_name,
444: pjip.salary_payer_name,
445: pjip.salary_payer_address
446: FROM pay_jp_isdf_pact_v pjip,
447: pay_assignment_actions paa
448: WHERE paa.assignment_action_id = p_mag_asg_action_id
449: AND paa.payroll_action_id = pjip.payroll_action_id;
450: --
451: isdf_employer_c cur_isdf_employer%ROWTYPE;
745: second_digit VARCHAR2(1);
746: ps_date_length NUMBER;
747: ps_date VARCHAR2(30);
748: spded_value NUMBER(6,2);
749: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
750: l_emp_no VARCHAR2(80);
751: line_life_gen NUMBER;
752: count_care_med NUMBER;
753: line_life_pen NUMBER;
1947: l_emp_no_opt := pay_core_utils.get_parameter('PRN_EMP_NO',l_legislative_parameters);
1948: --
1949: SELECT paa1.assignment_action_id
1950: INTO l_old_assact_id
1951: FROM pay_assignment_actions paa,
1952: pay_assignment_actions paa1
1953: WHERE paa.assignment_action_id = l_cur_assact
1954: AND paa.assignment_id = paa1.assignment_id
1955: AND paa1.payroll_action_id = l_pact_id;
1948: --
1949: SELECT paa1.assignment_action_id
1950: INTO l_old_assact_id
1951: FROM pay_assignment_actions paa,
1952: pay_assignment_actions paa1
1953: WHERE paa.assignment_action_id = l_cur_assact
1954: AND paa.assignment_id = paa1.assignment_id
1955: AND paa1.payroll_action_id = l_pact_id;
1956: --