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

Line 1490: from per_business_groups pbg

1486: l_session_c number(1):=2;
1487:
1488: cursor csr_bg is
1489: select legislation_code
1490: from per_business_groups pbg
1491: where pbg.business_group_id = p_business_group_id;
1492: --
1493: begin
1494:

Line 2350: from per_business_groups pbg

2346: l_asg_object_version_number number(9);
2347: --
2348: cursor csr_bg is
2349: select legislation_code
2350: from per_business_groups pbg
2351: where pbg.business_group_id = p_business_group_id;
2352: */
2353: --
2354: begin

Line 2654: from per_business_groups pbg

2650: l_asg_object_version_number number(9);
2651: --
2652: cursor csr_bg is
2653: select legislation_code
2654: from per_business_groups pbg
2655: where pbg.business_group_id = p_business_group_id;
2656: --
2657: begin
2658: --

Line 3056: ,per_business_groups bus

3052: ,p_effective_date IN DATE
3053: ) IS
3054: SELECT bus.legislation_code
3055: FROM per_people_f per
3056: ,per_business_groups bus
3057: WHERE per.person_id = csr_per_legislation.p_person_id
3058: AND per.business_group_id+0 = bus.business_group_id
3059: AND csr_per_legislation.p_effective_date BETWEEN per.effective_start_date
3060: AND per.effective_end_date;

Line 3611: l_organization_id per_business_groups.organization_id%type;

3607: l_business_group_id per_people_f.business_group_id%type;
3608: l_name_combination_warning boolean;
3609: l_dob_null_warning boolean;
3610: l_orig_hire_warning boolean;
3611: l_organization_id per_business_groups.organization_id%type;
3612: l_legislation_code per_business_groups.legislation_code%type;
3613: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3614: l_person_type_id1 per_people_f.person_type_id%type;
3615: l_application_id per_applications.application_id%type;

Line 3612: l_legislation_code per_business_groups.legislation_code%type;

3608: l_name_combination_warning boolean;
3609: l_dob_null_warning boolean;
3610: l_orig_hire_warning boolean;
3611: l_organization_id per_business_groups.organization_id%type;
3612: l_legislation_code per_business_groups.legislation_code%type;
3613: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3614: l_person_type_id1 per_people_f.person_type_id%type;
3615: l_application_id per_applications.application_id%type;
3616: l_comment_id per_assignments_f.comment_id%type;

Line 3632: l_default_start_time per_business_groups.default_start_time%type;

3628: l_system_person_type per_person_types.system_person_type%type;
3629: l_effective_date date;
3630: l_effective_start_date date;
3631: l_effective_end_date date;
3632: l_default_start_time per_business_groups.default_start_time%type;
3633: l_default_end_time per_business_groups.default_end_time%type;
3634: l_normal_hours number;
3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;

Line 3633: l_default_end_time per_business_groups.default_end_time%type;

3629: l_effective_date date;
3630: l_effective_start_date date;
3631: l_effective_end_date date;
3632: l_default_start_time per_business_groups.default_start_time%type;
3633: l_default_end_time per_business_groups.default_end_time%type;
3634: l_normal_hours number;
3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;

Line 3635: l_frequency per_business_groups.frequency%type;

3631: l_effective_end_date date;
3632: l_default_start_time per_business_groups.default_start_time%type;
3633: l_default_end_time per_business_groups.default_end_time%type;
3634: l_normal_hours number;
3635: l_frequency per_business_groups.frequency%type;
3636: l_recruiter_id per_vacancies.recruiter_id%type;
3637: l_grade_id per_vacancies.grade_id%type;
3638: l_position_id per_vacancies.position_id%type;
3639: l_job_id per_vacancies.job_id%type;

Line 3693: from per_business_groups

3689: ,default_start_time
3690: ,default_end_time
3691: ,fnd_number.canonical_to_number(working_hours)
3692: ,frequency
3693: from per_business_groups
3694: where business_group_id = l_business_group_id;
3695: --
3696: -- Get vacancy information.
3697: --

Line 4168: ,per_business_groups bus

4164: ,per.npw_number
4165: ,bus.business_group_id
4166: ,bus.legislation_code
4167: FROM per_people_f per
4168: ,per_business_groups bus
4169: ,per_person_types pet
4170: WHERE per.person_type_id = pet.person_type_id
4171: AND per.business_group_id+0 = bus.business_group_id
4172: AND per.person_id = csr_per_details.p_person_id