[Home] [Help]
1309:
1310: --Included the flollowing cursor for bug fix 1828519
1311: CURSOR employee_name_cur IS
1312: SELECT full_name
1313: FROM per_people_f ppf
1314: WHERE ppf.person_id = (SELECT pal.person_id
1315: FROM psp_adjustment_lines pal
1316: WHERE pal.payroll_control_id = gl_batch_rec.payroll_control_id
1317: AND rownum = 1); --Bug 2133056 removed distinct and replace batch_name with payroll_control_id
2943: WHERE time_period_id = gms_batch_rec.time_period_id;
2944:
2945: CURSOR employee_cur IS
2946: SELECT employee_number
2947: FROM per_people_f
2948: WHERE person_id = gms_interface_rec.person_id
2949: AND gms_interface_rec.effective_date BETWEEN effective_start_date AND effective_end_date;
2950:
2951: CURSOR task_number_cur IS
2965:
2966: -- Included the following cursor for bug fix 1828519
2967: CURSOR employee_name_cur IS
2968: SELECT full_name
2969: FROM per_people_f ppf
2970: WHERE ppf.person_id = (SELECT pal.person_id
2971: FROM psp_adjustment_lines pal
2972: WHERE pal.payroll_control_id = gms_batch_rec.payroll_control_id
2973: AND rownum = 1); -- Bug 2133056 Replaced batch_name with payroll_control_id and removed DISTINCT
3175: FETCH employee_cur INTO l_employee_number;
3176: IF (employee_cur%NOTFOUND)THEN
3177: CLOSE employee_cur;
3178: l_value := 'Person Id = '||to_char(gms_interface_rec.person_id);
3179: l_table := 'PER_PEOPLE_F';
3180: -- Included the following code for bug fix 1828519
3181: l_person_name := 'PERSON ID NOT FOUND';
3182: -- End of bug fix 1828519
3183: fnd_message.set_name('PSP','PSP_TR_VALUE_NOT_FOUND');
4870: WHERE adjustment_batch_name = p_batch_name;
4871:
4872: CURSOR person_name_cur IS
4873: SELECT substr(full_name, 1, 80)
4874: FROM per_people_f ppf1
4875: WHERE person_id = l_person_id
4876: AND trunc(sysdate) BETWEEN effective_start_date and effective_end_date ;
4877:
4878: