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 1255: from per_business_groups pbg

1251: l_legislation_code varchar2(30);
1252: --
1253: cursor csr_bg is
1254: select legislation_code
1255: from per_business_groups pbg
1256: where pbg.business_group_id = p_business_group_id;
1257: --
1258: begin
1259: hr_utility.set_location('Entering:'|| l_proc, 5);

Line 1512: l_legislation_code per_business_groups.legislation_code%TYPE;

1508: l_unaccepted_asg_del_warning boolean;
1509: --
1510: l_system_person_type per_person_types.system_person_type%TYPE;
1511: l_business_group_id per_all_people_f.business_group_id%TYPE;
1512: l_legislation_code per_business_groups.legislation_code%TYPE;
1513: l_applicant_number per_all_people_f.applicant_number%TYPE;
1514: l_application_id per_applications.application_id%TYPE;
1515: l_apl_object_version_number per_applications.application_id%TYPE;
1516: --

Line 1616: per_business_groups bus,

1612: pap.object_version_number,
1613: per.npw_number,
1614: per.original_date_of_hire -- #2978566
1615: from per_all_people_f per,
1616: per_business_groups bus,
1617: per_person_types ppt,
1618: per_applications pap
1619: where per.person_type_id = ppt.person_type_id
1620: and per.business_group_id = bus.business_group_id

Line 1797: from per_business_groups_perf pbg

1793: l_new_hire_code varchar2(30);
1794: --
1795: cursor csr_get_legislation_code is
1796: select legislation_code
1797: from per_business_groups_perf pbg
1798: ,per_all_people_f ppf
1799: where ppf.person_id = p_person_id
1800: and pbg.business_group_id+0 = ppf.business_group_id;
1801:

Line 3838: ,per_business_groups bus

3834: ,per.npw_number
3835: ,bus.business_group_id
3836: ,bus.legislation_code
3837: FROM per_people_f per
3838: ,per_business_groups bus
3839: ,per_person_types pet
3840: WHERE per.person_type_id = pet.person_type_id
3841: AND per.business_group_id+0 = bus.business_group_id
3842: AND per.person_id = csr_per_details.p_person_id

Line 4129: l_organization_id per_business_groups.organization_id%type;

4125: l_business_group_id per_people_f.business_group_id%type;
4126: l_name_combination_warning boolean;
4127: l_dob_null_warning boolean;
4128: l_orig_hire_warning boolean;
4129: l_organization_id per_business_groups.organization_id%type;
4130: l_legislation_code per_business_groups.legislation_code%type;
4131: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
4132: l_person_type_id1 per_people_f.person_type_id%type;
4133: l_application_id per_applications.application_id%type;

Line 4130: l_legislation_code per_business_groups.legislation_code%type;

4126: l_name_combination_warning boolean;
4127: l_dob_null_warning boolean;
4128: l_orig_hire_warning boolean;
4129: l_organization_id per_business_groups.organization_id%type;
4130: l_legislation_code per_business_groups.legislation_code%type;
4131: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
4132: l_person_type_id1 per_people_f.person_type_id%type;
4133: l_application_id per_applications.application_id%type;
4134: l_comment_id per_assignments_f.comment_id%type;

Line 4150: l_default_start_time per_business_groups.default_start_time%type;

4146: l_system_person_type per_person_types.system_person_type%type;
4147: l_effective_date date;
4148: l_effective_start_date date;
4149: l_effective_end_date date;
4150: l_default_start_time per_business_groups.default_start_time%type;
4151: l_default_end_time per_business_groups.default_end_time%type;
4152: l_normal_hours number;
4153: l_frequency per_business_groups.frequency%type;
4154: l_recruiter_id per_vacancies.recruiter_id%type;

Line 4151: l_default_end_time per_business_groups.default_end_time%type;

4147: l_effective_date date;
4148: l_effective_start_date date;
4149: l_effective_end_date date;
4150: l_default_start_time per_business_groups.default_start_time%type;
4151: l_default_end_time per_business_groups.default_end_time%type;
4152: l_normal_hours number;
4153: l_frequency per_business_groups.frequency%type;
4154: l_recruiter_id per_vacancies.recruiter_id%type;
4155: l_grade_id per_vacancies.grade_id%type;

Line 4153: l_frequency per_business_groups.frequency%type;

4149: l_effective_end_date date;
4150: l_default_start_time per_business_groups.default_start_time%type;
4151: l_default_end_time per_business_groups.default_end_time%type;
4152: l_normal_hours number;
4153: l_frequency per_business_groups.frequency%type;
4154: l_recruiter_id per_vacancies.recruiter_id%type;
4155: l_grade_id per_vacancies.grade_id%type;
4156: l_position_id per_vacancies.position_id%type;
4157: l_job_id per_vacancies.job_id%type;