APPS.HR_SUIT_MATCH_UTIL_SS dependencies on PER_ALL_VACANCIES

Line 151: FROM per_all_vacancies pv

147: SELECT pv.vacancy_id,
148: pv.organization_id,
149: pv.job_id,
150: pv.position_id
151: FROM per_all_vacancies pv
152: WHERE TRUNC(sysdate) BETWEEN pv.date_from
153: AND NVL(pv.date_to, TRUNC(sysdate))
154: AND pv.vacancy_id = p_vacancy_id;
155:

Line 532: l_vacancy_id per_all_vacancies.vacancy_id%type;

528: l_enterprise_id per_competence_elements.enterprise_id%type;
529: l_organization_id per_competence_elements.organization_id%type;
530: l_job_id per_competence_elements.job_id%type;
531: l_position_id per_competence_elements.position_id%type;
532: l_vacancy_id per_all_vacancies.vacancy_id%type;
533: is_vac_pos boolean default false;
534:
535: BEGIN
536:

Line 927: l_vacancy_id per_all_vacancies.vacancy_id%type;

923: l_enterprise_id per_competence_elements.enterprise_id%type;
924: l_organization_id per_competence_elements.organization_id%type;
925: l_job_id per_competence_elements.job_id%type;
926: l_position_id per_competence_elements.position_id%type;
927: l_vacancy_id per_all_vacancies.vacancy_id%type;
928: l_ess_des_match_count integer;
929: l_total_ess_des_count integer;
930: is_vac_pos boolean default false;
931:

Line 1027: l_vacancy_id per_all_vacancies.vacancy_id%type;

1023: l_enterprise_id per_competence_elements.enterprise_id%type;
1024: l_organization_id per_competence_elements.organization_id%type;
1025: l_job_id per_competence_elements.job_id%type;
1026: l_position_id per_competence_elements.position_id%type;
1027: l_vacancy_id per_all_vacancies.vacancy_id%type;
1028:
1029: l_ess_match_count integer;
1030: l_total_ess_count integer;
1031: l_des_match_count integer;