APPS.GHR_PDI_API dependencies on FND_USER

Line 99: fnd_user usr

95: per.first_name,
96: per.last_name,
97: per.middle_names
98: from per_people_f per,
99: fnd_user usr
100: where upper(usr.user_name) = upper(p_1_user_name_acted_on)
101: and per.person_id = usr.employee_id
102: and p_date_from
103: between per.effective_start_date

Line 113: fnd_user usr

109: per.first_name,
110: per.last_name,
111: per.middle_names
112: FROM per_people_f per,
113: fnd_user usr
114: WHERE usr.user_name = UPPER(p_1_user_name_acted_on)
115: AND per.person_id = usr.employee_id
116: AND p_date_from
117: BETWEEN per.effective_start_date

Line 671: FROM fnd_user usr,

667: SELECT usr.employee_id,
668: per.first_name,
669: per.last_name,
670: per.middle_names
671: FROM fnd_user usr,
672: per_people_f per
673: WHERE upper(p_u_user_name_acted_on) = upper(usr.user_name)
674: AND per.person_id = usr.employee_id
675: AND p_date_from

Line 685: FROM fnd_user usr,

681: SELECT usr.employee_id,
682: per.first_name,
683: per.last_name,
684: per.middle_names
685: FROM fnd_user usr,
686: per_people_f per
687: WHERE usr.user_name = UPPER(p_u_user_name_acted_on)
688: AND per.person_id = usr.employee_id
689: AND p_date_from