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_API dependencies on PER_BUSINESS_GROUPS

Line 991: from per_business_groups pbg

987: l_legislation_code varchar2(30);
988: --
989: cursor csr_bg is
990: select legislation_code
991: from per_business_groups pbg
992: where pbg.business_group_id = p_business_group_id;
993: --
994: begin
995: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 1257: from per_business_groups pbg

1253: l_legislation_code varchar2(30);
1254: --
1255: cursor csr_bg is
1256: select legislation_code
1257: from per_business_groups pbg
1258: where pbg.business_group_id = p_business_group_id;
1259: */
1260: --
1261: begin

Line 1525: from per_business_groups pbg

1521: l_legislation_code varchar2(30);
1522: --
1523: cursor csr_bg is
1524: select legislation_code
1525: from per_business_groups pbg
1526: where pbg.business_group_id = p_business_group_id;
1527: --
1528: begin
1529: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 1839: l_legislation_code per_business_groups.legislation_code%TYPE;

1835: l_unaccepted_asg_del_warning boolean;
1836: --
1837: l_system_person_type per_person_types.system_person_type%TYPE;
1838: l_business_group_id per_all_people_f.business_group_id%TYPE;
1839: l_legislation_code per_business_groups.legislation_code%TYPE;
1840: l_applicant_number per_all_people_f.applicant_number%TYPE;
1841: l_application_id per_applications.application_id%TYPE;
1842: l_apl_object_version_number per_applications.application_id%TYPE;
1843: --

Line 2022: per_business_groups bus,

2018: pap.object_version_number,
2019: per.npw_number,
2020: per.original_date_of_hire -- #2978566
2021: from per_all_people_f per,
2022: per_business_groups bus,
2023: per_person_types ppt,
2024: per_applications pap
2025: where per.person_type_id = ppt.person_type_id
2026: and per.business_group_id = bus.business_group_id

Line 2205: from per_business_groups_perf pbg

2201: l_new_hire_code varchar2(30);
2202: --
2203: cursor csr_get_legislation_code is
2204: select legislation_code
2205: from per_business_groups_perf pbg
2206: ,per_all_people_f ppf
2207: where ppf.person_id = p_person_id
2208: and pbg.business_group_id+0 = ppf.business_group_id;
2209:

Line 4911: ,per_business_groups bus

4907: ,per.npw_number
4908: ,bus.business_group_id
4909: ,bus.legislation_code
4910: FROM per_people_f per
4911: ,per_business_groups bus
4912: ,per_person_types pet
4913: WHERE per.person_type_id = pet.person_type_id
4914: AND per.business_group_id+0 = bus.business_group_id
4915: AND per.person_id = csr_per_details.p_person_id

Line 5202: l_organization_id per_business_groups.organization_id%type;

5198: l_business_group_id per_people_f.business_group_id%type;
5199: l_name_combination_warning boolean;
5200: l_dob_null_warning boolean;
5201: l_orig_hire_warning boolean;
5202: l_organization_id per_business_groups.organization_id%type;
5203: l_legislation_code per_business_groups.legislation_code%type;
5204: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
5205: l_person_type_id1 per_people_f.person_type_id%type;
5206: l_application_id per_applications.application_id%type;

Line 5203: l_legislation_code per_business_groups.legislation_code%type;

5199: l_name_combination_warning boolean;
5200: l_dob_null_warning boolean;
5201: l_orig_hire_warning boolean;
5202: l_organization_id per_business_groups.organization_id%type;
5203: l_legislation_code per_business_groups.legislation_code%type;
5204: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
5205: l_person_type_id1 per_people_f.person_type_id%type;
5206: l_application_id per_applications.application_id%type;
5207: l_comment_id per_assignments_f.comment_id%type;

Line 5223: l_default_start_time per_business_groups.default_start_time%type;

5219: l_system_person_type per_person_types.system_person_type%type;
5220: l_effective_date date;
5221: l_effective_start_date date;
5222: l_effective_end_date date;
5223: l_default_start_time per_business_groups.default_start_time%type;
5224: l_default_end_time per_business_groups.default_end_time%type;
5225: l_normal_hours number;
5226: l_frequency per_business_groups.frequency%type;
5227: l_recruiter_id per_vacancies.recruiter_id%type;

Line 5224: l_default_end_time per_business_groups.default_end_time%type;

5220: l_effective_date date;
5221: l_effective_start_date date;
5222: l_effective_end_date date;
5223: l_default_start_time per_business_groups.default_start_time%type;
5224: l_default_end_time per_business_groups.default_end_time%type;
5225: l_normal_hours number;
5226: l_frequency per_business_groups.frequency%type;
5227: l_recruiter_id per_vacancies.recruiter_id%type;
5228: l_grade_id per_vacancies.grade_id%type;

Line 5226: l_frequency per_business_groups.frequency%type;

5222: l_effective_end_date date;
5223: l_default_start_time per_business_groups.default_start_time%type;
5224: l_default_end_time per_business_groups.default_end_time%type;
5225: l_normal_hours number;
5226: l_frequency per_business_groups.frequency%type;
5227: l_recruiter_id per_vacancies.recruiter_id%type;
5228: l_grade_id per_vacancies.grade_id%type;
5229: l_position_id per_vacancies.position_id%type;
5230: l_job_id per_vacancies.job_id%type;