APPS.POS_COMPARE_REVISIONS dependencies on FND_USER

Line 5038: * p_work_approver_id Unique identifier in fnd_user.

5034: * PURPOSE
5035: * Resolves the owner name.
5036: *
5037: * ARGUMENTS
5038: * p_work_approver_id Unique identifier in fnd_user.
5039: *
5040: * NOTES
5041: * Return NULL if no matching records were found.
5042: *

Line 5059: hecv, fnd_user fu

5055:
5056: select hecv.full_name
5057: INTO v_full_name
5058: from PER_PEOPLE_F --hr_employees_current_v
5059: hecv, fnd_user fu
5060: where fu.user_id = p_work_approver_id and
5061: fu.employee_id = hecv.person_id (+) --employee_id (+)
5062: and rownum = 1
5063: order by hecv.effective_start_date desc ;