DBA Data[Home] [Help]

APPS.HR_SECURITY dependencies on FND_USER

Line 165: from fnd_user

161: where security_profile_id=p_security_profile_id;
162: --
163: cursor get_user_person_id(p_user_id number) is
164: select employee_id
165: from fnd_user
166: where user_id=p_user_id;
167: --
168: l_person_id number;
169: --

Line 279: FROM fnd_user fndu

275: --
276: CURSOR csr_get_person
277: (p_user_id IN NUMBER) IS
278: SELECT fndu.employee_id
279: FROM fnd_user fndu
280: WHERE p_user_id IS NOT NULL
281: AND fndu.user_id = p_user_id;
282:
283: --

Line 2078: ,fnd_user usr

2074: CURSOR CSR_TEAM is
2075: Select 1
2076: from irc_rec_team_members team
2077: ,per_all_people_f per
2078: ,fnd_user usr
2079: where team.vacancy_id = p_vacancy_id
2080: and team.party_id = nvl(per.party_id, usr.customer_id)
2081: and per.person_id(+) = usr.employee_id
2082: and sysdate between per.effective_start_date