APPS.IRC_SKILLS_MATCHING_PKG dependencies on PER_ALL_VACANCIES

Line 72: CURSOR gc_get_vac_scopes(cp_vacancy per_all_vacancies.vacancy_id%TYPE,

68: WHERE competence_id = CP_COMPETENCE_ID
69: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)
70: ORDER BY step_value;
71:
72: CURSOR gc_get_vac_scopes(cp_vacancy per_all_vacancies.vacancy_id%TYPE,
73: cp_date per_all_vacancies.date_to%TYPE) IS
74: SELECT organization_id,business_group_id,position_id,job_id
75: FROM per_all_vacancies
76: WHERE vacancy_id = CP_VACANCY

Line 73: cp_date per_all_vacancies.date_to%TYPE) IS

69: AND ( step_value = CP_STEP_VALUE1 or step_value = CP_STEP_VALUE2)
70: ORDER BY step_value;
71:
72: CURSOR gc_get_vac_scopes(cp_vacancy per_all_vacancies.vacancy_id%TYPE,
73: cp_date per_all_vacancies.date_to%TYPE) IS
74: SELECT organization_id,business_group_id,position_id,job_id
75: FROM per_all_vacancies
76: WHERE vacancy_id = CP_VACANCY
77: AND CP_DATE between nvl(date_from,trunc(SYSDATE))

Line 75: FROM per_all_vacancies

71:
72: CURSOR gc_get_vac_scopes(cp_vacancy per_all_vacancies.vacancy_id%TYPE,
73: cp_date per_all_vacancies.date_to%TYPE) IS
74: SELECT organization_id,business_group_id,position_id,job_id
75: FROM per_all_vacancies
76: WHERE vacancy_id = CP_VACANCY
77: AND CP_DATE between nvl(date_from,trunc(SYSDATE))
78: and nvl(date_to,hr_api.g_eot);
79:

Line 642: CURSOR lc_get_vac_requirements(cp_vacancy_id per_all_vacancies.vacancy_id%TYPE) IS

638: p_eff_date date default sysdate) RETURN VARCHAR2
639:
640: IS
641:
642: CURSOR lc_get_vac_requirements(cp_vacancy_id per_all_vacancies.vacancy_id%TYPE) IS
643: select competence_id,
644: nvl(mandatory,'N') as mandatory,
645: nvl(proficiency_level_id,-1) as proficiency_level_id,
646: nvl(high_proficiency_level_id,-1) as high_proficiency_level_id