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_RECRUITMENT_SUMMARY_PKG dependencies on PER_ALL_VACANCIES

Line 66: from per_all_vacancies vac

62:
63: )
64: select vac.vacancy_id, vac.manager_id, vac.recruiter_id, vac.organization_id, vac.budget_measurement_value,
65: 'NEW',l_start_date
66: from per_all_vacancies vac
67: where vac.vacancy_id in (
68: select vac1.vacancy_id from per_all_vacancies vac1 where vac1.status NOT IN('CLOSED','CLO')
69: and trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate))
70: );

Line 68: select vac1.vacancy_id from per_all_vacancies vac1 where vac1.status NOT IN('CLOSED','CLO')

64: select vac.vacancy_id, vac.manager_id, vac.recruiter_id, vac.organization_id, vac.budget_measurement_value,
65: 'NEW',l_start_date
66: from per_all_vacancies vac
67: where vac.vacancy_id in (
68: select vac1.vacancy_id from per_all_vacancies vac1 where vac1.status NOT IN('CLOSED','CLO')
69: and trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate))
70: );
71: log(SQL%ROWCOUNT||' rows inserted into table IRC_VAC_SUMMARY successfully');
72: log('Leaving procedure INIT_FULL_REFRESH');

Line 94: from per_all_vacancies vac

90: (
91: vacancy_id,processed_status
92: )
93: select vac.vacancy_id, 'NEW'
94: from per_all_vacancies vac
95: where
96: vac.vacancy_id not in(
97: select vacancy_id from irc_vac_summary
98: )

Line 100: select vacancy_id from per_all_vacancies where status not in ('CLOSED','CLO')

96: vac.vacancy_id not in(
97: select vacancy_id from irc_vac_summary
98: )
99: and vac.vacancy_id in(
100: select vacancy_id from per_all_vacancies where status not in ('CLOSED','CLO')
101: and trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate))
102: );
103: log(SQL%ROWCOUNT||' rows inserted into table IRC_VAC_SUMMARY successfully');
104: --delete all the vacancies from irc_vac_summary which do not fulfill the required criteria;

Line 107: select vacancy_id from per_all_vacancies where status not in ('CLOSED','CLO')

103: log(SQL%ROWCOUNT||' rows inserted into table IRC_VAC_SUMMARY successfully');
104: --delete all the vacancies from irc_vac_summary which do not fulfill the required criteria;
105: delete from irc_vac_summary ivs
106: where ivs.vacancy_id not in(
107: select vacancy_id from per_all_vacancies where status not in ('CLOSED','CLO')
108: and trunc(sysdate) between date_from and nvl(date_to,trunc(sysdate))
109: );
110: log(SQL%ROWCOUNT||' rows deleted from table IRC_VAC_SUMMARY successfully');
111: --delete all the data from irc_vac_summary_details,irc_vac_recruiters,irc_vac_managers

Line 427: per_all_vacancies pav,

423: select
424: distinct ivs.rowid,ivs.vacancy_id,ivs.processed_status
425: from
426: irc_vac_summary ivs,
427: per_all_vacancies pav,
428: per_all_assignments_f paf,
429: irc_offers iof
430: where
431: pav.vacancy_id = ivs.vacancy_id

Line 484: from per_all_vacancies vac

480: vac.recruiter_id,
481: vac.organization_id,
482: vac.budget_measurement_value,
483: l_start_date
484: from per_all_vacancies vac
485: where ivs.vacancy_id = vac.vacancy_id
486: )
487: where ivs.vacancy_id = l_vacancy_id;
488: --