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_BUSINESS_GROUPS

Line 107: l_legislation_code per_business_groups.legislation_code%TYPE;

103: l_comment_id per_assignments_f.comment_id%TYPE;
104: l_correction boolean;
105: l_datetrack_mode varchar2(30);
106: l_entries_changed varchar2(1);
107: l_legislation_code per_business_groups.legislation_code%TYPE;
108: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
109: l_no_managers_warning boolean;
110: l_org_now_no_manager_warning boolean;
111: l_pay_proposal_warning boolean := FALSE; -- Bug 3202260

Line 130: from per_business_groups bus

126: g_package || 'actual_term_cwk_asg';
127: --
128: cursor csr_get_legislation_code is
129: select bus.legislation_code
130: from per_business_groups bus
131: where bus.business_group_id = l_business_group_id;
132: --
133: cursor csr_asg_values (l_effective_date date) is
134: select asg.object_version_number

Line 514: l_legislation_code per_business_groups.legislation_code%TYPE;

510: l_object_version_number per_assignments_f.object_version_number%TYPE;
511: l_org_now_no_manager_warning boolean := FALSE;
512: --
513: l_business_group_id per_assignments_f.business_group_id%TYPE;
514: l_legislation_code per_business_groups.legislation_code%TYPE;
515: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
516: l_proc varchar2(72) :=
517: g_package || 'final_process_cwk_asg';
518: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

Line 525: from per_business_groups_perf pbg

521: --
522: --
523: cursor csr_get_busgrp_legislation is
524: select pbg.business_group_id, pbg.legislation_code
525: from per_business_groups_perf pbg
526: where pbg.business_group_id = (select distinct asg.business_group_id from
527: per_assignments_f asg
528: where asg.assignment_id = p_assignment_id);
529:

Line 987: l_legislation_code per_business_groups.legislation_code%TYPE;

983: l_comment_id per_assignments_f.comment_id%TYPE;
984: l_correction boolean;
985: l_datetrack_mode varchar2(30);
986: l_entries_changed varchar2(1);
987: l_legislation_code per_business_groups.legislation_code%TYPE;
988: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
989: l_no_managers_warning boolean;
990: l_org_now_no_manager_warning boolean;
991: l_pay_proposal_warning boolean := FALSE; -- Bug 3202260

Line 1010: from per_business_groups bus

1006: g_package || 'actual_term_emp_asg_sup';
1007: --
1008: cursor csr_get_legislation_code is
1009: select bus.legislation_code
1010: from per_business_groups bus
1011: where bus.business_group_id = l_business_group_id;
1012: --
1013: cursor csr_asg_values (l_effective_date date) is
1014: select asg.object_version_number

Line 1549: l_location_id per_business_groups.location_id%TYPE;

1545: ) is
1546: --
1547: -- Declare cursors and local variables
1548: --
1549: l_location_id per_business_groups.location_id%TYPE;
1550: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1551: l_time_normal_start per_business_groups.default_start_time%TYPE;
1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;

Line 1550: l_time_normal_finish per_business_groups.default_end_time%TYPE;

1546: --
1547: -- Declare cursors and local variables
1548: --
1549: l_location_id per_business_groups.location_id%TYPE;
1550: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1551: l_time_normal_start per_business_groups.default_start_time%TYPE;
1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 1551: l_time_normal_start per_business_groups.default_start_time%TYPE;

1547: -- Declare cursors and local variables
1548: --
1549: l_location_id per_business_groups.location_id%TYPE;
1550: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1551: l_time_normal_start per_business_groups.default_start_time%TYPE;
1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 1553: l_frequency per_business_groups.frequency%TYPE;

1549: l_location_id per_business_groups.location_id%TYPE;
1550: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1551: l_time_normal_start per_business_groups.default_start_time%TYPE;
1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1557: l_assignment_number per_assignments_f.assignment_number%TYPE;

Line 1554: l_legislation_code per_business_groups.legislation_code%TYPE;

1550: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1551: l_time_normal_start per_business_groups.default_start_time%TYPE;
1552: l_normal_hours number;
1553: l_frequency per_business_groups.frequency%TYPE;
1554: l_legislation_code per_business_groups.legislation_code%TYPE;
1555: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1556: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1557: l_assignment_number per_assignments_f.assignment_number%TYPE;
1558: l_comment_id per_assignments_f.comment_id%TYPE;

Line 1569: from per_business_groups bus

1565: , bus.default_start_time
1566: , fnd_number.canonical_to_number(bus.working_hours)
1567: , bus.frequency
1568: , bus.legislation_code
1569: from per_business_groups bus
1570: where bus.business_group_id = p_business_group_id;
1571: --
1572: begin
1573: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2205: l_legislation_code per_business_groups.legislation_code%TYPE;

2201: l_cost_warning boolean;
2202: l_life_events_exists boolean;
2203: --
2204: l_business_group_id per_assignments_f.business_group_id%TYPE;
2205: l_legislation_code per_business_groups.legislation_code%TYPE;
2206: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2207: l_proc varchar2(72) :=
2208: g_package || 'final_process_emp_asg_sup';
2209: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

Line 2216: from per_business_groups_perf pbg

2212: --
2213: --
2214: cursor csr_get_busgrp_legislation is
2215: select pbg.business_group_id, pbg.legislation_code
2216: from per_business_groups_perf pbg
2217: where pbg.business_group_id = (select distinct asg.business_group_id from
2218: per_assignments_f asg
2219: where asg.assignment_id = p_assignment_id);
2220: --

Line 4608: l_legislation_code per_business_groups.legislation_code%TYPE;

4604: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4605: l_assignment_type per_assignments_f.assignment_type%TYPE;
4606: l_business_group_id per_assignments_f.business_group_id%TYPE;
4607: l_comment_id per_assignments_f.comment_id%TYPE;
4608: l_legislation_code per_business_groups.legislation_code%TYPE;
4609: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4610: l_no_managers_warning boolean;
4611: l_other_manager_warning boolean;
4612: l_hourly_salaried_warning boolean;

Line 4625: , per_business_groups_perf bus

4621: select asg.assignment_type
4622: , asg.business_group_id
4623: , bus.legislation_code
4624: from per_assignments_f asg
4625: , per_business_groups_perf bus
4626: where asg.assignment_id = p_assignment_id
4627: and p_effective_date between asg.effective_start_date
4628: and asg.effective_end_date
4629: and bus.business_group_id+0 = asg.business_group_id;

Line 4773: l_legislation_code per_business_groups.legislation_code%TYPE;

4769: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4770: l_assignment_type per_assignments_f.assignment_type%TYPE;
4771: l_business_group_id per_assignments_f.business_group_id%TYPE;
4772: l_comment_id per_assignments_f.comment_id%TYPE;
4773: l_legislation_code per_business_groups.legislation_code%TYPE;
4774: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4775: l_no_managers_warning boolean;
4776: l_other_manager_warning boolean;
4777: l_hourly_salaried_warning boolean;

Line 4790: , per_business_groups_perf bus

4786: select asg.assignment_type
4787: , asg.business_group_id
4788: , bus.legislation_code
4789: from per_assignments_f asg
4790: , per_business_groups_perf bus
4791: where asg.assignment_id = p_assignment_id
4792: and p_effective_date between asg.effective_start_date
4793: and asg.effective_end_date
4794: and bus.business_group_id+0 = asg.business_group_id;

Line 5248: l_location_id per_business_groups.location_id%TYPE;

5244: ) is
5245: --
5246: -- Declare cursors and local variables
5247: --
5248: l_location_id per_business_groups.location_id%TYPE;
5249: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5250: l_time_normal_start per_business_groups.default_start_time%TYPE;
5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;

Line 5249: l_time_normal_finish per_business_groups.default_end_time%TYPE;

5245: --
5246: -- Declare cursors and local variables
5247: --
5248: l_location_id per_business_groups.location_id%TYPE;
5249: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5250: l_time_normal_start per_business_groups.default_start_time%TYPE;
5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 5250: l_time_normal_start per_business_groups.default_start_time%TYPE;

5246: -- Declare cursors and local variables
5247: --
5248: l_location_id per_business_groups.location_id%TYPE;
5249: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5250: l_time_normal_start per_business_groups.default_start_time%TYPE;
5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 5252: l_frequency per_business_groups.frequency%TYPE;

5248: l_location_id per_business_groups.location_id%TYPE;
5249: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5250: l_time_normal_start per_business_groups.default_start_time%TYPE;
5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5256: l_assignment_number per_assignments_f.assignment_number%TYPE;

Line 5253: l_legislation_code per_business_groups.legislation_code%TYPE;

5249: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5250: l_time_normal_start per_business_groups.default_start_time%TYPE;
5251: l_normal_hours number;
5252: l_frequency per_business_groups.frequency%TYPE;
5253: l_legislation_code per_business_groups.legislation_code%TYPE;
5254: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5255: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5256: l_assignment_number per_assignments_f.assignment_number%TYPE;
5257: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5268: from per_business_groups bus

5264: , bus.default_start_time
5265: , fnd_number.canonical_to_number(bus.working_hours)
5266: , bus.frequency
5267: , bus.legislation_code
5268: from per_business_groups bus
5269: where bus.business_group_id = p_business_group_id;
5270: --
5271: begin
5272: --

Line 5583: l_location_id per_business_groups.location_id%TYPE;

5579: ) is
5580: --
5581: -- Declare cursors and local variables
5582: --
5583: l_location_id per_business_groups.location_id%TYPE;
5584: -- Bug 4325900
5585: l_vac_location_id per_all_vacancies.location_id%TYPE;
5586: -- Bug 4520212
5587: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;

Line 5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;

5591: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5594:
5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5596: l_time_normal_start per_business_groups.default_start_time%TYPE;
5597: l_normal_hours number;
5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 5596: l_time_normal_start per_business_groups.default_start_time%TYPE;

5592: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5593: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5594:
5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5596: l_time_normal_start per_business_groups.default_start_time%TYPE;
5597: l_normal_hours number;
5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;
5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 5598: l_frequency per_business_groups.frequency%TYPE;

5594:
5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5596: l_time_normal_start per_business_groups.default_start_time%TYPE;
5597: l_normal_hours number;
5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;
5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5601: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5602: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5599: l_legislation_code per_business_groups.legislation_code%TYPE;

5595: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5596: l_time_normal_start per_business_groups.default_start_time%TYPE;
5597: l_normal_hours number;
5598: l_frequency per_business_groups.frequency%TYPE;
5599: l_legislation_code per_business_groups.legislation_code%TYPE;
5600: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5601: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5602: l_comment_id per_assignments_f.comment_id%TYPE;
5603: l_proc varchar2(72):=g_package||'create_default_apl_asg';

Line 5612: from per_business_groups bus

5608: , bus.default_end_time
5609: , fnd_number.canonical_to_number(bus.working_hours)
5610: , bus.frequency
5611: , bus.legislation_code
5612: from per_business_groups bus
5613: where bus.business_group_id = p_business_group_id;
5614: --
5615: -- Bug 4325900 Starts
5616: cursor csr_get_vac_loc is

Line 5743: l_legislation_code per_business_groups.legislation_code%TYPE;

5739: l_assignment_type per_assignments_f.assignment_type%TYPE;
5740: l_person_id per_assignments_f.person_id%TYPE;
5741: l_business_group_id per_assignments_f.business_group_id%TYPE;
5742: l_comment_id per_assignments_f.comment_id%TYPE;
5743: l_legislation_code per_business_groups.legislation_code%TYPE;
5744: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5745: l_no_managers_warning boolean;
5746: l_other_manager_warning boolean;
5747: l_payroll_id_updated boolean;

Line 5762: , per_business_groups_perf bus

5758: , asg.person_id
5759: , asg.business_group_id
5760: , bus.legislation_code
5761: from per_assignments_f asg
5762: , per_business_groups_perf bus
5763: where asg.assignment_id = p_assignment_id
5764: and p_effective_date between asg.effective_start_date
5765: and asg.effective_end_date
5766: and bus.business_group_id+0 = asg.business_group_id;

Line 6093: l_legislation_code per_business_groups.legislation_code%TYPE; --added for bug 6917728

6089: l_pay_basis_id number; -- Added for Bug 4764140
6090: --
6091: l_warning_text varchar2(240);
6092: l_loc_code varchar2(100);
6093: l_legislation_code per_business_groups.legislation_code%TYPE; --added for bug 6917728
6094: --
6095: cursor csr_ass_sys_type is
6096: select per_system_status
6097: from per_assignment_status_types

Line 6119: from per_business_groups bus

6115: --
6116: --start changes for bug 6917728
6117: cursor csr_get_legislation_code is
6118: select bus.legislation_code
6119: from per_business_groups bus
6120: where bus.business_group_id = per_asg_shd.g_old_rec.business_group_id;
6121: --start changes for bug 6917728
6122:
6123: l_proc varchar2(72) := g_package||'pre_delete';