DBA Data[Home] [Help]

APPS.HR_SECURITY dependencies on FND_USER

Line 149: from fnd_user

145: where security_profile_id=p_security_profile_id;
146: --
147: cursor get_user_person_id(p_user_id number) is
148: select employee_id
149: from fnd_user
150: where user_id=p_user_id;
151: --
152: l_person_id number;
153: --

Line 253: FROM fnd_user fndu

249: --
250: CURSOR csr_get_person
251: (p_user_id IN NUMBER) IS
252: SELECT fndu.employee_id
253: FROM fnd_user fndu
254: WHERE p_user_id IS NOT NULL
255: AND fndu.user_id = p_user_id;
256:
257: --

Line 1621: ,fnd_user usr

1617: CURSOR CSR_TEAM is
1618: Select 1
1619: from irc_rec_team_members team
1620: ,per_all_people_f per
1621: ,fnd_user usr
1622: where team.vacancy_id = p_vacancy_id
1623: and team.party_id = nvl(per.party_id, usr.customer_id)
1624: and per.person_id(+) = usr.employee_id
1625: and sysdate between per.effective_start_date