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 549: l_legislation_code per_business_groups.legislation_code%TYPE;

545: l_object_version_number per_assignments_f.object_version_number%TYPE;
546: l_org_now_no_manager_warning boolean := FALSE;
547: --
548: l_business_group_id per_assignments_f.business_group_id%TYPE;
549: l_legislation_code per_business_groups.legislation_code%TYPE;
550: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
551: l_proc varchar2(72) :=
552: g_package || 'final_process_cwk_asg';
553: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

Line 560: from per_business_groups_perf pbg

556: --
557: --
558: cursor csr_get_busgrp_legislation is
559: select pbg.business_group_id, pbg.legislation_code
560: from per_business_groups_perf pbg
561: where pbg.business_group_id = (select distinct asg.business_group_id from
562: per_assignments_f asg
563: where asg.assignment_id = p_assignment_id);
564:

Line 1053: l_legislation_code per_business_groups.legislation_code%TYPE;

1049: l_comment_id per_assignments_f.comment_id%TYPE;
1050: l_correction boolean;
1051: l_datetrack_mode varchar2(30);
1052: l_entries_changed varchar2(1);
1053: l_legislation_code per_business_groups.legislation_code%TYPE;
1054: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
1055: l_no_managers_warning boolean;
1056: l_org_now_no_manager_warning boolean;
1057: l_pay_proposal_warning boolean := FALSE; -- Bug 3202260

Line 1076: from per_business_groups bus

1072: g_package || 'actual_term_emp_asg_sup';
1073: --
1074: cursor csr_get_legislation_code is
1075: select bus.legislation_code
1076: from per_business_groups bus
1077: where bus.business_group_id = l_business_group_id;
1078: --
1079: cursor csr_asg_values (l_effective_date date) is
1080: select asg.object_version_number

Line 1648: l_location_id per_business_groups.location_id%TYPE;

1644: ) is
1645: --
1646: -- Declare cursors and local variables
1647: --
1648: l_location_id per_business_groups.location_id%TYPE;
1649: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1650: l_time_normal_start per_business_groups.default_start_time%TYPE;
1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;

Line 1649: l_time_normal_finish per_business_groups.default_end_time%TYPE;

1645: --
1646: -- Declare cursors and local variables
1647: --
1648: l_location_id per_business_groups.location_id%TYPE;
1649: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1650: l_time_normal_start per_business_groups.default_start_time%TYPE;
1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 1650: l_time_normal_start per_business_groups.default_start_time%TYPE;

1646: -- Declare cursors and local variables
1647: --
1648: l_location_id per_business_groups.location_id%TYPE;
1649: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1650: l_time_normal_start per_business_groups.default_start_time%TYPE;
1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 1652: l_frequency per_business_groups.frequency%TYPE;

1648: l_location_id per_business_groups.location_id%TYPE;
1649: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1650: l_time_normal_start per_business_groups.default_start_time%TYPE;
1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1656: l_assignment_number per_assignments_f.assignment_number%TYPE;

Line 1653: l_legislation_code per_business_groups.legislation_code%TYPE;

1649: l_time_normal_finish per_business_groups.default_end_time%TYPE;
1650: l_time_normal_start per_business_groups.default_start_time%TYPE;
1651: l_normal_hours number;
1652: l_frequency per_business_groups.frequency%TYPE;
1653: l_legislation_code per_business_groups.legislation_code%TYPE;
1654: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
1655: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
1656: l_assignment_number per_assignments_f.assignment_number%TYPE;
1657: l_comment_id per_assignments_f.comment_id%TYPE;

Line 1668: from per_business_groups bus

1664: , bus.default_start_time
1665: , fnd_number.canonical_to_number(bus.working_hours)
1666: , bus.frequency
1667: , bus.legislation_code
1668: from per_business_groups bus
1669: where bus.business_group_id = p_business_group_id;
1670: --
1671: begin
1672: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 2307: l_legislation_code per_business_groups.legislation_code%TYPE;

2303: l_cost_warning boolean;
2304: l_life_events_exists boolean;
2305: --
2306: l_business_group_id per_assignments_f.business_group_id%TYPE;
2307: l_legislation_code per_business_groups.legislation_code%TYPE;
2308: l_max_asg_end_date per_assignments_f.effective_end_date%TYPE;
2309: l_proc varchar2(72) :=
2310: g_package || 'final_process_emp_asg_sup';
2311: l_validation_start_date per_assignments_f.effective_start_date%TYPE;

Line 2318: from per_business_groups_perf pbg

2314: --
2315: --
2316: cursor csr_get_busgrp_legislation is
2317: select pbg.business_group_id, pbg.legislation_code
2318: from per_business_groups_perf pbg
2319: where pbg.business_group_id = (select distinct asg.business_group_id from
2320: per_assignments_f asg
2321: where asg.assignment_id = p_assignment_id);
2322: --

Line 4741: l_legislation_code per_business_groups.legislation_code%TYPE;

4737: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4738: l_assignment_type per_assignments_f.assignment_type%TYPE;
4739: l_business_group_id per_assignments_f.business_group_id%TYPE;
4740: l_comment_id per_assignments_f.comment_id%TYPE;
4741: l_legislation_code per_business_groups.legislation_code%TYPE;
4742: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4743: l_no_managers_warning boolean;
4744: l_other_manager_warning boolean;
4745: l_hourly_salaried_warning boolean;

Line 4758: , per_business_groups_perf bus

4754: select asg.assignment_type
4755: , asg.business_group_id
4756: , bus.legislation_code
4757: from per_assignments_f asg
4758: , per_business_groups_perf bus
4759: where asg.assignment_id = p_assignment_id
4760: and p_effective_date between asg.effective_start_date
4761: and asg.effective_end_date
4762: and bus.business_group_id+0 = asg.business_group_id;

Line 4906: l_legislation_code per_business_groups.legislation_code%TYPE;

4902: l_assignment_status_type_id per_assignments_f.assignment_status_type_id%TYPE;
4903: l_assignment_type per_assignments_f.assignment_type%TYPE;
4904: l_business_group_id per_assignments_f.business_group_id%TYPE;
4905: l_comment_id per_assignments_f.comment_id%TYPE;
4906: l_legislation_code per_business_groups.legislation_code%TYPE;
4907: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4908: l_no_managers_warning boolean;
4909: l_other_manager_warning boolean;
4910: l_hourly_salaried_warning boolean;

Line 4923: , per_business_groups_perf bus

4919: select asg.assignment_type
4920: , asg.business_group_id
4921: , bus.legislation_code
4922: from per_assignments_f asg
4923: , per_business_groups_perf bus
4924: where asg.assignment_id = p_assignment_id
4925: and p_effective_date between asg.effective_start_date
4926: and asg.effective_end_date
4927: and bus.business_group_id+0 = asg.business_group_id;

Line 5383: l_location_id per_business_groups.location_id%TYPE;

5379: ) is
5380: --
5381: -- Declare cursors and local variables
5382: --
5383: l_location_id per_business_groups.location_id%TYPE;
5384: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5385: l_time_normal_start per_business_groups.default_start_time%TYPE;
5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;

Line 5384: l_time_normal_finish per_business_groups.default_end_time%TYPE;

5380: --
5381: -- Declare cursors and local variables
5382: --
5383: l_location_id per_business_groups.location_id%TYPE;
5384: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5385: l_time_normal_start per_business_groups.default_start_time%TYPE;
5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 5385: l_time_normal_start per_business_groups.default_start_time%TYPE;

5381: -- Declare cursors and local variables
5382: --
5383: l_location_id per_business_groups.location_id%TYPE;
5384: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5385: l_time_normal_start per_business_groups.default_start_time%TYPE;
5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 5387: l_frequency per_business_groups.frequency%TYPE;

5383: l_location_id per_business_groups.location_id%TYPE;
5384: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5385: l_time_normal_start per_business_groups.default_start_time%TYPE;
5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5391: l_assignment_number per_assignments_f.assignment_number%TYPE;

Line 5388: l_legislation_code per_business_groups.legislation_code%TYPE;

5384: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5385: l_time_normal_start per_business_groups.default_start_time%TYPE;
5386: l_normal_hours number;
5387: l_frequency per_business_groups.frequency%TYPE;
5388: l_legislation_code per_business_groups.legislation_code%TYPE;
5389: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5390: l_effective_end_date per_assignments_f.effective_start_date%TYPE;
5391: l_assignment_number per_assignments_f.assignment_number%TYPE;
5392: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5403: from per_business_groups bus

5399: , bus.default_start_time
5400: , fnd_number.canonical_to_number(bus.working_hours)
5401: , bus.frequency
5402: , bus.legislation_code
5403: from per_business_groups bus
5404: where bus.business_group_id = p_business_group_id;
5405: --
5406: begin
5407: --

Line 5718: l_location_id per_business_groups.location_id%TYPE;

5714: ) is
5715: --
5716: -- Declare cursors and local variables
5717: --
5718: l_location_id per_business_groups.location_id%TYPE;
5719: -- Bug 4325900
5720: l_vac_location_id per_all_vacancies.location_id%TYPE;
5721: -- Bug 4520212
5722: l_org_id per_all_vacancies.business_group_id%TYPE := p_business_group_id;

Line 5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;

5726: l_vac_job_id per_all_vacancies.job_id%TYPE ;
5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5729:
5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5731: l_time_normal_start per_business_groups.default_start_time%TYPE;
5732: l_normal_hours number;
5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 5731: l_time_normal_start per_business_groups.default_start_time%TYPE;

5727: l_vac_position_id per_all_vacancies.position_id%TYPE ;
5728: l_vac_grade_id per_all_vacancies.grade_id%TYPE ;
5729:
5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5731: l_time_normal_start per_business_groups.default_start_time%TYPE;
5732: l_normal_hours number;
5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;

Line 5733: l_frequency per_business_groups.frequency%TYPE;

5729:
5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5731: l_time_normal_start per_business_groups.default_start_time%TYPE;
5732: l_normal_hours number;
5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5737: l_comment_id per_assignments_f.comment_id%TYPE;

Line 5734: l_legislation_code per_business_groups.legislation_code%TYPE;

5730: l_time_normal_finish per_business_groups.default_end_time%TYPE;
5731: l_time_normal_start per_business_groups.default_start_time%TYPE;
5732: l_normal_hours number;
5733: l_frequency per_business_groups.frequency%TYPE;
5734: l_legislation_code per_business_groups.legislation_code%TYPE;
5735: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
5736: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
5737: l_comment_id per_assignments_f.comment_id%TYPE;
5738: l_proc varchar2(72):=g_package||'create_default_apl_asg';

Line 5747: from per_business_groups bus

5743: , bus.default_end_time
5744: , fnd_number.canonical_to_number(bus.working_hours)
5745: , bus.frequency
5746: , bus.legislation_code
5747: from per_business_groups bus
5748: where bus.business_group_id = p_business_group_id;
5749: --
5750: -- Bug 4325900 Starts
5751: cursor csr_get_vac_loc is

Line 5878: l_legislation_code per_business_groups.legislation_code%TYPE;

5874: l_assignment_type per_assignments_f.assignment_type%TYPE;
5875: l_person_id per_assignments_f.person_id%TYPE;
5876: l_business_group_id per_assignments_f.business_group_id%TYPE;
5877: l_comment_id per_assignments_f.comment_id%TYPE;
5878: l_legislation_code per_business_groups.legislation_code%TYPE;
5879: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
5880: l_no_managers_warning boolean;
5881: l_other_manager_warning boolean;
5882: l_payroll_id_updated boolean;

Line 5897: , per_business_groups_perf bus

5893: , asg.person_id
5894: , asg.business_group_id
5895: , bus.legislation_code
5896: from per_assignments_f asg
5897: , per_business_groups_perf bus
5898: where asg.assignment_id = p_assignment_id
5899: and p_effective_date between asg.effective_start_date
5900: and asg.effective_end_date
5901: and bus.business_group_id+0 = asg.business_group_id;

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

6303: l_new_emp_cat varchar2(30); -- Bug#13960540
6304: --
6305: l_warning_text varchar2(240);
6306: l_loc_code varchar2(100);
6307: l_legislation_code per_business_groups.legislation_code%TYPE; --added for bug 6917728
6308: --
6309: cursor csr_ass_sys_type is
6310: select per_system_status
6311: from per_assignment_status_types

Line 6333: from per_business_groups bus

6329: --
6330: --start changes for bug 6917728
6331: cursor csr_get_legislation_code is
6332: select bus.legislation_code
6333: from per_business_groups bus
6334: where bus.business_group_id = per_asg_shd.g_old_rec.business_group_id;
6335: --start changes for bug 6917728
6336:
6337: l_proc varchar2(72) := g_package||'pre_delete';