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.HR_APPLICANT_INTERNAL dependencies on PER_VACANCIES

Line 2309: l_recruiter_id per_vacancies.recruiter_id%type;

2305: l_default_start_time per_business_groups.default_start_time%type;
2306: l_default_end_time per_business_groups.default_end_time%type;
2307: l_normal_hours number;
2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;

Line 2310: l_grade_id per_vacancies.grade_id%type;

2306: l_default_end_time per_business_groups.default_end_time%type;
2307: l_normal_hours number;
2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;

Line 2311: l_position_id per_vacancies.position_id%type;

2307: l_normal_hours number;
2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;
2315: l_vac_organization_id per_vacancies.organization_id%type;

Line 2312: l_job_id per_vacancies.job_id%type;

2308: l_frequency per_business_groups.frequency%type;
2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;
2315: l_vac_organization_id per_vacancies.organization_id%type;
2316: l_vac_business_group_id per_vacancies.business_group_id%type;

Line 2313: l_location_id per_vacancies.location_id%type;

2309: l_recruiter_id per_vacancies.recruiter_id%type;
2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;
2315: l_vac_organization_id per_vacancies.organization_id%type;
2316: l_vac_business_group_id per_vacancies.business_group_id%type;
2317: l_group_name pay_people_groups.group_name%type;

Line 2314: l_people_group_id per_vacancies.people_group_id%type;

2310: l_grade_id per_vacancies.grade_id%type;
2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;
2315: l_vac_organization_id per_vacancies.organization_id%type;
2316: l_vac_business_group_id per_vacancies.business_group_id%type;
2317: l_group_name pay_people_groups.group_name%type;
2318: --

Line 2315: l_vac_organization_id per_vacancies.organization_id%type;

2311: l_position_id per_vacancies.position_id%type;
2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;
2315: l_vac_organization_id per_vacancies.organization_id%type;
2316: l_vac_business_group_id per_vacancies.business_group_id%type;
2317: l_group_name pay_people_groups.group_name%type;
2318: --
2319: --

Line 2316: l_vac_business_group_id per_vacancies.business_group_id%type;

2312: l_job_id per_vacancies.job_id%type;
2313: l_location_id per_vacancies.location_id%type;
2314: l_people_group_id per_vacancies.people_group_id%type;
2315: l_vac_organization_id per_vacancies.organization_id%type;
2316: l_vac_business_group_id per_vacancies.business_group_id%type;
2317: l_group_name pay_people_groups.group_name%type;
2318: --
2319: --
2320: l_apl_object_version_number number;

Line 2376: from per_vacancies

2372: ,location_id
2373: ,people_group_id
2374: ,organization_id -- added org id to cursor. thayden 7/10.
2375: ,business_group_id -- added business_group_id to cursor lma 7/11
2376: from per_vacancies
2377: where vacancy_id = p_vacancy_id;
2378: --
2379: CURSOR csr_lock_person(cp_person_id number, cp_termination_date date) IS
2380: SELECT null