DBA Data[Home] [Help]

APPS.HR_SECURITY_INTERNAL dependencies on IRC_REC_TEAM_MEMBERS

Line 4257: irc_rec_team_members irt

4253: cursor csr_rtm_candidates(p_person_id number) is
4254: select paaf.person_id,paaf.assignment_id
4255: from per_all_people_f papf,
4256: per_all_assignments_f paaf,
4257: irc_rec_team_members irt
4258: where papf.person_id = paaf.person_id
4259: and nvl(paaf.vacancy_id,(select distinct vacancy_id from PER_VAC_LINKED_ASSIGNMENTS
4260: where tgt_apl_asg_id=paaf.assignment_id and rownum<2)) = irt.vacancy_id
4261: and sysdate between paaf.effective_start_date and paaf.effective_end_date