APPS.HR_SECURITY dependencies on IRC_REC_TEAM_MEMBERS

Line 270: FROM irc_rec_team_members

266:
267: CURSOR csr_get_if_rtm(p_person_id number)
268: IS
269: SELECT vacancy_id
270: FROM irc_rec_team_members
271: WHERE person_id = p_person_id;
272:
273: --
274: -- Gets the person stored against a given user.

Line 2076: from irc_rec_team_members team

2072: RETURN VARCHAR2
2073: IS
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)