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

2072: l_asg_object_version_number number(9);
2073: --
2074: cursor csr_bg is
2075: select legislation_code
2076: from per_business_groups pbg
2077: where pbg.business_group_id = p_business_group_id;
2078: --
2079: begin
2080: --

Line 2745: ,per_business_groups bus

2741: ,p_effective_date IN DATE
2742: ) IS
2743: SELECT bus.legislation_code
2744: FROM per_people_f per
2745: ,per_business_groups bus
2746: WHERE per.person_id = csr_per_legislation.p_person_id
2747: AND per.business_group_id+0 = bus.business_group_id
2748: AND csr_per_legislation.p_effective_date BETWEEN per.effective_start_date
2749: AND per.effective_end_date;

Line 3299: l_organization_id per_business_groups.organization_id%type;

3295: l_business_group_id per_people_f.business_group_id%type;
3296: l_name_combination_warning boolean;
3297: l_dob_null_warning boolean;
3298: l_orig_hire_warning boolean;
3299: l_organization_id per_business_groups.organization_id%type;
3300: l_legislation_code per_business_groups.legislation_code%type;
3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;

Line 3300: l_legislation_code per_business_groups.legislation_code%type;

3296: l_name_combination_warning boolean;
3297: l_dob_null_warning boolean;
3298: l_orig_hire_warning boolean;
3299: l_organization_id per_business_groups.organization_id%type;
3300: l_legislation_code per_business_groups.legislation_code%type;
3301: l_person_type_id per_people_f.person_type_id%type := p_person_type_id;
3302: l_person_type_id1 per_people_f.person_type_id%type;
3303: l_application_id per_applications.application_id%type;
3304: l_comment_id per_assignments_f.comment_id%type;

Line 3320: l_default_start_time per_business_groups.default_start_time%type;

3316: l_system_person_type per_person_types.system_person_type%type;
3317: l_effective_date date;
3318: l_effective_start_date date;
3319: l_effective_end_date date;
3320: l_default_start_time per_business_groups.default_start_time%type;
3321: l_default_end_time per_business_groups.default_end_time%type;
3322: l_normal_hours number;
3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;

Line 3321: l_default_end_time per_business_groups.default_end_time%type;

3317: l_effective_date date;
3318: l_effective_start_date date;
3319: l_effective_end_date date;
3320: l_default_start_time per_business_groups.default_start_time%type;
3321: l_default_end_time per_business_groups.default_end_time%type;
3322: l_normal_hours number;
3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;

Line 3323: l_frequency per_business_groups.frequency%type;

3319: l_effective_end_date date;
3320: l_default_start_time per_business_groups.default_start_time%type;
3321: l_default_end_time per_business_groups.default_end_time%type;
3322: l_normal_hours number;
3323: l_frequency per_business_groups.frequency%type;
3324: l_recruiter_id per_vacancies.recruiter_id%type;
3325: l_grade_id per_vacancies.grade_id%type;
3326: l_position_id per_vacancies.position_id%type;
3327: l_job_id per_vacancies.job_id%type;

Line 3381: from per_business_groups

3377: ,default_start_time
3378: ,default_end_time
3379: ,fnd_number.canonical_to_number(working_hours)
3380: ,frequency
3381: from per_business_groups
3382: where business_group_id = l_business_group_id;
3383: --
3384: -- Get vacancy information.
3385: --

Line 3856: ,per_business_groups bus

3852: ,per.npw_number
3853: ,bus.business_group_id
3854: ,bus.legislation_code
3855: FROM per_people_f per
3856: ,per_business_groups bus
3857: ,per_person_types pet
3858: WHERE per.person_type_id = pet.person_type_id
3859: AND per.business_group_id+0 = bus.business_group_id
3860: AND per.person_id = csr_per_details.p_person_id