DBA Data[Home] [Help]

APPS.RCV_TRANSACTION_SV dependencies on HR_EMPLOYEES

Line 222: from per_employees_current_x -- Bug 7257731: Changed the view name from hr_employees to per_employees_current_x

218: BEGIN
219: x_progress := 10;
220: select full_name
221: into x_name
222: from per_employees_current_x -- Bug 7257731: Changed the view name from hr_employees to per_employees_current_x
223: where employee_id = x_employee_id;
224:
225: RETURN(x_name);
226:

Line 418: from hr_employees_current_v

414:
415: if x_deliver_to_person_id is not null then--Bug#6497729
416: select 'Check to see if deliver_to_person_id is valid'
417: into x_del_per_val
418: from hr_employees_current_v
419: WHERE (inactive_date IS NULL
420: OR
421: inactive_date > x_date)
422: AND employee_id = x_deliver_to_person_id;

Line 569: l_dummy_person HR_EMPLOYEES.full_name%TYPE;

565: l_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
566: l_dest_subinv PO_DISTRIBUTIONS.destination_subinventory%TYPE;
567: l_dummy_rate PO_DISTRIBUTIONS.rate%TYPE;
568: l_dummy_rate_date PO_DISTRIBUTIONS.rate_date%TYPE;
569: l_dummy_person HR_EMPLOYEES.full_name%TYPE;
570: l_dummy_subinv PO_REQUISITION_LINES.destination_subinventory%TYPE;
571: --
572:
573: BEGIN