APPS.POS_COMPARE_REVISIONS dependencies on FND_USER

Line 5044: * p_work_approver_id Unique identifier in fnd_user.

5040: * PURPOSE
5041: * Resolves the owner name.
5042: *
5043: * ARGUMENTS
5044: * p_work_approver_id Unique identifier in fnd_user.
5045: *
5046: * NOTES
5047: * Return NULL if no matching records were found.
5048: *

Line 5065: hecv, fnd_user fu

5061:
5062: select hecv.full_name
5063: INTO v_full_name
5064: from PER_PEOPLE_F --hr_employees_current_v
5065: hecv, fnd_user fu
5066: where fu.user_id = p_work_approver_id and
5067: fu.employee_id = hecv.person_id (+) --employee_id (+)
5068: and rownum = 1
5069: order by hecv.effective_start_date desc ;