[Home] [Help]
862: where person_id=p_person_id
863: and trunc(sysdate) between
864: effective_start_date and effective_end_date)
865: and ppf.business_group_id in
866: (select business_group_id from per_all_vacancies
867: where vacancy_id=p_vacancy_id);
868: --
869: cursor csr_get_data is
870: select ipd.pending_data_id
954: -- External Candidates won't be displayed Internal vacancies so we don't have
955: -- to check their applications
956: --
957: cursor csr_is_internal_vacancy(p_vacancy_id in number, p_application_date in date) is
958: select 1 from per_all_vacancies pav, per_recruitment_activities pra,
959: per_recruitment_activity_for prf, irc_all_recruiting_sites ias
960: where pav.vacancy_id = prf.vacancy_id AND
961: prf.recruitment_activity_id = pra.recruitment_activity_id AND
962: trunc(p_application_date) between PRA.date_start and nvl(PRA.date_end,trunc(p_application_date))
1358: ,ipd.error_message
1359: ,ipd.resume_file_name
1360: ,pav.name
1361: from irc_pending_data ipd
1362: ,per_all_vacancies pav
1363: where ipd.vacancy_id = pav.vacancy_id(+)
1364: and ipd.processed in ('A','R','E','F')
1365: order by ipd.email_address, ipd.creation_date desc;
1366: --
1375: from irc_posting_contents_vl ipc
1376: where ipc.posting_content_id = p_posting_content_id;
1377: --
1378: type vacancies_table is
1379: table of per_all_vacancies.name%type
1380: index by binary_integer;
1381: --
1382: type comments_table is
1383: table of varchar2(1000)