APPS.HR_SUIT_MATCH_UTIL_SS dependencies on PER_ALL_VACANCIES

Line 158: FROM per_all_vacancies pv

154: SELECT pv.vacancy_id,
155: pv.organization_id,
156: pv.job_id,
157: pv.position_id
158: FROM per_all_vacancies pv
159: WHERE TRUNC(sysdate) BETWEEN pv.date_from
160: AND NVL(pv.date_to, TRUNC(sysdate))
161: AND pv.vacancy_id = p_vacancy_id;
162:

Line 538: l_vacancy_id per_all_vacancies.vacancy_id%type;

534: l_enterprise_id per_competence_elements.enterprise_id%type;
535: l_organization_id per_competence_elements.organization_id%type;
536: l_job_id per_competence_elements.job_id%type;
537: l_position_id per_competence_elements.position_id%type;
538: l_vacancy_id per_all_vacancies.vacancy_id%type;
539: is_vac_pos boolean default false;
540:
541: BEGIN
542:

Line 938: l_vacancy_id per_all_vacancies.vacancy_id%type;

934: l_enterprise_id per_competence_elements.enterprise_id%type;
935: l_organization_id per_competence_elements.organization_id%type;
936: l_job_id per_competence_elements.job_id%type;
937: l_position_id per_competence_elements.position_id%type;
938: l_vacancy_id per_all_vacancies.vacancy_id%type;
939: l_ess_des_match_count integer;
940: l_total_ess_des_count integer;
941: is_vac_pos boolean default false;
942:

Line 1045: l_vacancy_id per_all_vacancies.vacancy_id%type;

1041: l_enterprise_id per_competence_elements.enterprise_id%type;
1042: l_organization_id per_competence_elements.organization_id%type;
1043: l_job_id per_competence_elements.job_id%type;
1044: l_position_id per_competence_elements.position_id%type;
1045: l_vacancy_id per_all_vacancies.vacancy_id%type;
1046:
1047: l_ess_match_count integer;
1048: l_total_ess_count integer;
1049: l_des_match_count integer;