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 5720: l_vac_location_id per_all_vacancies.location_id%TYPE;

5716: -- Declare cursors and local variables
5717: --
5718: l_location_id per_business_groups.location_id%TYPE;
5719: -- Bug 4325900
5720: l_vac_location_id per_all_vacancies.location_id%TYPE;
5721: -- Bug 4520212
5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;

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

5718: l_location_id per_business_groups.location_id%TYPE;
5719: -- Bug 4325900
5720: l_vac_location_id per_all_vacancies.location_id%TYPE;
5721: -- Bug 4520212
5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;

Line 5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;

5719: -- Bug 4325900
5720: l_vac_location_id per_all_vacancies.location_id%TYPE;
5721: -- Bug 4520212
5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;

Line 5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;

5720: l_vac_location_id per_all_vacancies.location_id%TYPE;
5721: -- Bug 4520212
5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;

Line 5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;

5721: -- Bug 4520212
5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5729:

Line 5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;

5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;
5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5729:
5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;

Line 5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;

5723: l_vac_org_id per_all_vacancies.business_group_id%TYPE ;
5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5729:
5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5731: l_time_normal_start per_business_groups.default_start_time%TYPE;

Line 5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;

5724: l_vac_pgp_id per_all_vacancies.people_group_id%TYPE ;
5725: l_vac_rec_id per_all_vacancies.recruiter_id%TYPE ;
5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5729:
5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5731: l_time_normal_start per_business_groups.default_start_time%TYPE;
5732: l_normal_hours number;

Line 5753: from PER_ALL_VACANCIES

5749: --
5750: -- Bug 4325900 Starts
5751: cursor csr_get_vac_loc is
5752: select location_id,people_group_id,recruiter_id,job_id,position_id,grade_id,organization_id
5753: from PER_ALL_VACANCIES
5754: where vacancy_id = p_vacancy_id
5755: and p_effective_date between date_from
5756: and nvl(date_to, hr_api.g_eot);
5757: -- Bug 4325900 Ends