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_ASSIGNMENT_INTERNAL dependencies on PER_ALL_VACANCIES

Line 5585: l_vac_location_id per_all_vacancies.location_id%TYPE;

5581: -- Declare cursors and local variables
5582: --
5583: l_location_id per_business_groups.location_id%TYPE;
5584: -- Bug 4325900
5585: l_vac_location_id per_all_vacancies.location_id%TYPE;
5586: -- Bug 4520212
5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;

Line 5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;

5583: l_location_id per_business_groups.location_id%TYPE;
5584: -- Bug 4325900
5585: l_vac_location_id per_all_vacancies.location_id%TYPE;
5586: -- Bug 4520212
5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;

Line 5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;

5584: -- Bug 4325900
5585: l_vac_location_id per_all_vacancies.location_id%TYPE;
5586: -- Bug 4520212
5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;

Line 5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;

5585: l_vac_location_id per_all_vacancies.location_id%TYPE;
5586: -- Bug 4520212
5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;

Line 5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;

5586: -- Bug 4520212
5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5594:

Line 5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;

5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5594:
5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;

Line 5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;

5588: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5594:
5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5596: l_time_normal_start per_business_groups.default_start_time%TYPE;

Line 5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;

5589: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5590: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5594:
5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5596: l_time_normal_start per_business_groups.default_start_time%TYPE;
5597: l_normal_hours number;

Line 5618: from PER_ALL_VACANCIES

5614: --
5615: -- Bug 4325900 Starts
5616: cursor csr_get_vac_loc is
5617: select location_id,people_group_id,recruiter_id,job_id,position_id,grade_id,organization_id
5618: from PER_ALL_VACANCIES
5619: where vacancy_id = p_vacancy_id
5620: and p_effective_date between date_from
5621: and nvl(date_to, hr_api.g_eot);
5622: -- Bug 4325900 Ends