[Home] [Help]
275: IS
276: SELECT distinct pjiav.assignment_id, pjiav.effective_date
277: FROM per_all_assignments_f paa,
278: per_all_people_f pap,
279: pay_assignment_actions pas,
280: pay_jp_isdf_assact_v pjiav
281: WHERE paa.person_id between p_start_person_id and p_end_person_id
282: AND paa.person_id = pap.person_id
283: AND sysdate between pap.effective_start_date and pap.effective_end_date
292: or pjiav.transaction_status = decode(trans_stat,'Y','F')
293: or pjiav.transaction_status = decode(trans_stat,'Y','N')
294: or pjiav.transaction_status = decode(trans_stat,'Y','U')); -- Last condition in where clause added for Bug Fix:5487428
295: --
296: l_assact pay_assignment_actions.assignment_action_id%type ;
297: l_proc_name VARCHAR2(60);
298: l_old_pact_id NUMBER;
299: l_cur_pact NUMBER;
300: l_legislative_parameters VARCHAR2(2000);
343: FOR i IN c_assact(l_old_pact_id,l_prn_app_opt) LOOP
344: -- Added NVL to overcome NULL issue.
345: IF (NVL(l_ass_set_id,0) = 0) THEN
346: -- NO assignment set passed as parameter
347: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
348: hr_nonrun_asact.insact(l_assact,
349: i.assignment_id ,
350: p_payroll_action_id,
351: p_chunk,
361: IF (g_all_exclusions_flag = 0) THEN
362: -- assignment set by ammmendment passed is not all exclusions.
363: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
364: IF (l_result1 = 'I') THEN
365: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
366: hr_nonrun_asact.insact(l_assact,
367: i.assignment_id ,
368: p_payroll_action_id,
369: p_chunk,
373: ELSE
374: -- assignment set by ammmendment passed is all exclusions.
375: l_result1 := get_amendment_flag(i.assignment_id, l_ass_set_id);
376: IF (l_result1 <> 'E') THEN
377: SELECT pay_assignment_actions_s.nextval INTO l_assact FROM dual;
378: hr_nonrun_asact.insact(l_assact,
379: i.assignment_id ,
380: p_payroll_action_id,
381: p_chunk,
387: ELSE
388: -- assignment set by criteria passed
389: l_result2 := chk_ass_set(i.assignment_id, l_ass_set_id, l_formula_id, i.effective_date, g_dummy);
390: IF (l_result2 = TRUE) THEN
391: SELECT pay_assignment_actions_s.nextval into l_assact from dual;
392: hr_nonrun_asact.insact(l_assact,
393: i.assignment_id ,
394: p_payroll_action_id,
395: p_chunk,
442: pjip.tax_office_name,
443: pjip.salary_payer_name,
444: pjip.salary_payer_address
445: FROM pay_jp_isdf_pact_v pjip,
446: pay_assignment_actions paa
447: WHERE paa.assignment_action_id = p_mag_asg_action_id
448: AND paa.payroll_action_id = pjip.payroll_action_id;
449: --
450: isdf_employer_c cur_isdf_employer%ROWTYPE;
690: second_digit VARCHAR2(1);
691: ps_date_length NUMBER;
692: ps_date VARCHAR2(30);
693: spded_value NUMBER(6,2);
694: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
695: l_emp_no VARCHAR2(80);
696: --
697: l_c13 varchar2(60);
698: l_c14 varchar2(60);
1417: l_emp_no_opt := pay_core_utils.get_parameter('PRN_EMP_NO',l_legislative_parameters);
1418: --
1419: SELECT paa1.assignment_action_id
1420: INTO l_old_assact_id
1421: FROM pay_assignment_actions paa,
1422: pay_assignment_actions paa1
1423: WHERE paa.assignment_action_id = l_cur_assact
1424: AND paa.assignment_id = paa1.assignment_id
1425: AND paa1.payroll_action_id = l_pact_id;
1418: --
1419: SELECT paa1.assignment_action_id
1420: INTO l_old_assact_id
1421: FROM pay_assignment_actions paa,
1422: pay_assignment_actions paa1
1423: WHERE paa.assignment_action_id = l_cur_assact
1424: AND paa.assignment_id = paa1.assignment_id
1425: AND paa1.payroll_action_id = l_pact_id;
1426: --