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 2092: l_recruiter_id per_vacancies.recruiter_id%type;

2088: l_default_start_time per_business_groups.default_start_time%type;
2089: l_default_end_time per_business_groups.default_end_time%type;
2090: l_normal_hours number;
2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;

Line 2093: l_grade_id per_vacancies.grade_id%type;

2089: l_default_end_time per_business_groups.default_end_time%type;
2090: l_normal_hours number;
2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;

Line 2094: l_position_id per_vacancies.position_id%type;

2090: l_normal_hours number;
2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;
2098: l_vac_organization_id per_vacancies.organization_id%type;

Line 2095: l_job_id per_vacancies.job_id%type;

2091: l_frequency per_business_groups.frequency%type;
2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;
2098: l_vac_organization_id per_vacancies.organization_id%type;
2099: l_vac_business_group_id per_vacancies.business_group_id%type;

Line 2096: l_location_id per_vacancies.location_id%type;

2092: l_recruiter_id per_vacancies.recruiter_id%type;
2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;
2098: l_vac_organization_id per_vacancies.organization_id%type;
2099: l_vac_business_group_id per_vacancies.business_group_id%type;
2100: l_group_name pay_people_groups.group_name%type;

Line 2097: l_people_group_id per_vacancies.people_group_id%type;

2093: l_grade_id per_vacancies.grade_id%type;
2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;
2098: l_vac_organization_id per_vacancies.organization_id%type;
2099: l_vac_business_group_id per_vacancies.business_group_id%type;
2100: l_group_name pay_people_groups.group_name%type;
2101: --

Line 2098: l_vac_organization_id per_vacancies.organization_id%type;

2094: l_position_id per_vacancies.position_id%type;
2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;
2098: l_vac_organization_id per_vacancies.organization_id%type;
2099: l_vac_business_group_id per_vacancies.business_group_id%type;
2100: l_group_name pay_people_groups.group_name%type;
2101: --
2102: --

Line 2099: l_vac_business_group_id per_vacancies.business_group_id%type;

2095: l_job_id per_vacancies.job_id%type;
2096: l_location_id per_vacancies.location_id%type;
2097: l_people_group_id per_vacancies.people_group_id%type;
2098: l_vac_organization_id per_vacancies.organization_id%type;
2099: l_vac_business_group_id per_vacancies.business_group_id%type;
2100: l_group_name pay_people_groups.group_name%type;
2101: --
2102: --
2103: l_apl_object_version_number number;

Line 2159: from per_vacancies

2155: ,location_id
2156: ,people_group_id
2157: ,organization_id -- added org id to cursor. thayden 7/10.
2158: ,business_group_id -- added business_group_id to cursor lma 7/11
2159: from per_vacancies
2160: where vacancy_id = p_vacancy_id;
2161: --
2162: CURSOR csr_lock_person(cp_person_id number, cp_termination_date date) IS
2163: SELECT null