APPS.EAM_ASSET_OPERATION_TXN_PVT dependencies on FND_USER

Line 707: -- valid fnd_user validation

703: END IF;
704:
705:
706:
707: -- valid fnd_user validation
708:
709: SELECT
710: count(*)
711: INTO l_count

Line 712: FROM fnd_user

708:
709: SELECT
710: count(*)
711: INTO l_count
712: FROM fnd_user
713: WHERE p_employee_id=user_id;
714:
715: IF (l_count=0 OR l_count IS NULL)
716: THEN

Line 1132: FROM fnd_user fu,per_people_f ppf

1128:
1129:
1130: SELECT DISTINCT nvl(ppf.full_name,fu.user_name)
1131: INTO l_reference
1132: FROM fnd_user fu,per_people_f ppf
1133: WHERE fu.employee_id=ppf.person_id(+)
1134: AND fu.user_id=p_employee_id
1135: AND sysdate BETWEEN fu.start_date AND nvl(fu.end_date,sysdate)
1136: AND sysdate BETWEEN ppf.effective_start_date AND nvl(ppf.effective_end_date,sysdate)