APPS.AP_IMPORT_VALIDATION_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 5570: FROM hr_employees_current_v

5566: -- Bug 13074307: Validate all requester info provided and make sure
5567: -- they belongs to one record in HRMS
5568: SELECT count(*)
5569: INTO l_emp_count
5570: FROM hr_employees_current_v
5571: Where Employee_Id = nvl(P_Invoice_Rec.Requester_Id, Employee_Id)
5572: AND Last_Name = nvl(P_Invoice_Rec.requester_Last_Name, Last_Name)
5573: AND First_Name = nvl(P_Invoice_Rec.Requester_First_Name, First_Name)
5574: AND employee_num = nvl(p_invoice_rec.requester_employee_num, employee_num);

Line 5607: FROM hr_employees_current_v

5603: /* IF (p_invoice_rec.requester_id IS NOT NULL) THEN
5604:
5605: SELECT count(*)
5606: INTO l_emp_count
5607: FROM hr_employees_current_v
5608: WHERE employee_id = p_invoice_rec.requester_id;
5609:
5610: IF l_emp_count = 0 THEN
5611:

Line 5637: From Hr_Employees_Current_V

5633:
5634: Begin
5635: Select Employee_Id
5636: INTO p_invoice_rec.requester_id
5637: From Hr_Employees_Current_V
5638: Where (Last_Name) =(P_Invoice_Rec.requester_Last_Name)
5639: And (First_Name) =(P_Invoice_Rec.Requester_First_Name);
5640:
5641: Exception

Line 5667: FROM hr_employees_current_v

5663: Begin
5664:
5665: Select Employee_Id
5666: INTO p_invoice_rec.requester_id
5667: FROM hr_employees_current_v
5668: WHERE employee_num = p_invoice_rec.requester_employee_num;
5669:
5670: Exception
5671: When Others Then