eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_COMMUNICATIONS_API dependencies on PER_ALL_VACANCIES

Line 1486: Cursor cur_rec_mgr(p_vacancy_id per_all_vacancies.vacancy_id%TYPE) is

1482: and ic.communication_id = ict.communication_id
1483: and icp.communication_property_id = ic.communication_property_id
1484: and icp.object_type = 'VACANCY' ;
1485: --
1486: Cursor cur_rec_mgr(p_vacancy_id per_all_vacancies.vacancy_id%TYPE) is
1487: --get recruiter_id and hiring_manager_id for a given vacancy
1488: select pav.recruiter_id
1489: ,pav.manager_id
1490: from

Line 1491: per_all_vacancies pav

1487: --get recruiter_id and hiring_manager_id for a given vacancy
1488: select pav.recruiter_id
1489: ,pav.manager_id
1490: from
1491: per_all_vacancies pav
1492: where
1493: pav.vacancy_id = p_vacancy_id;
1494: --
1495: Cursor cur_team(p_vacancy_id per_all_vacancies.vacancy_id%TYPE) is

Line 1495: Cursor cur_team(p_vacancy_id per_all_vacancies.vacancy_id%TYPE) is

1491: per_all_vacancies pav
1492: where
1493: pav.vacancy_id = p_vacancy_id;
1494: --
1495: Cursor cur_team(p_vacancy_id per_all_vacancies.vacancy_id%TYPE) is
1496: --get recruiting team members for a given vacancy
1497: select team.person_id
1498: from
1499: irc_rec_team_members team