[Home] [Help]
1217:
1218: --Included the flollowing cursor for bug fix 1828519
1219: CURSOR employee_name_cur IS
1220: SELECT full_name
1221: FROM per_people_f ppf
1222: WHERE ppf.person_id = (SELECT pal.person_id
1223: FROM psp_adjustment_lines pal
1224: WHERE pal.payroll_control_id = gl_batch_rec.payroll_control_id
1225: AND rownum = 1); --Bug 2133056 removed distinct and replace batch_name with payroll_control_id
2799: WHERE time_period_id = gms_batch_rec.time_period_id;
2800:
2801: CURSOR employee_cur IS
2802: SELECT employee_number
2803: FROM per_people_f
2804: WHERE person_id = gms_interface_rec.person_id
2805: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
2806:
2807: CURSOR task_number_cur IS
2821:
2822: -- Included the following cursor for bug fix 1828519
2823: CURSOR employee_name_cur IS
2824: SELECT full_name
2825: FROM per_people_f ppf
2826: WHERE ppf.person_id = (SELECT pal.person_id
2827: FROM psp_adjustment_lines pal
2828: WHERE pal.payroll_control_id = gms_batch_rec.payroll_control_id
2829: AND rownum = 1); -- Bug 2133056 Replaced batch_name with payroll_control_id and removed DISTINCT
3019: FETCH employee_cur INTO l_employee_number;
3020: IF (employee_cur%NOTFOUND)THEN
3021: CLOSE employee_cur;
3022: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3023: l_table := 'PER_PEOPLE_F';
3024: -- Included the following code for bug fix 1828519
3025: l_person_name := 'PERSON ID NOT FOUND';
3026: -- End of bug fix 1828519
3027: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4439: WHERE adjustment_batch_name = p_batch_name;
4440:
4441: CURSOR person_name_cur IS
4442: SELECT substr(full_name, 1, 80)
4443: FROM per_people_f ppf1
4444: WHERE person_id = l_person_id
4445: AND trunc(sysdate) BETWEEN effective_start_date and effective_end_date ;
4446:
4447: