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.BEN_ASSIGNMENT_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 143: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

139: l_proc varchar2(72) := g_package||'create_ben_asg';
140: --
141: l_effective_date date;
142: l_date_probation_end date;
143: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
144: l_business_group_id number;
145: l_legislation_code per_business_groups.legislation_code%TYPE;
146: l_assignment_id number;
147: l_object_version_number number;

Line 192: from per_all_assignments_f asg,

188: ,c_eff_date in date
189: )
190: is
191: select null
192: from per_all_assignments_f asg,
193: per_assignment_status_types ast
194: where asg.person_id = c_person_id
195: and asg.assignment_type <> 'C'
196: and asg.assignment_status_type_id = ast.assignment_status_type_id

Line 927: l_comment_id per_all_assignments_f.comment_id%TYPE;

923: --
924: l_proc varchar2(72) := g_package||'update_ben_asg';
925: -- Out variables
926: --
927: l_comment_id per_all_assignments_f.comment_id%TYPE;
928: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
929: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
930: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
931: l_no_managers_warning boolean;

Line 928: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

924: l_proc varchar2(72) := g_package||'update_ben_asg';
925: -- Out variables
926: --
927: l_comment_id per_all_assignments_f.comment_id%TYPE;
928: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
929: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
930: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
931: l_no_managers_warning boolean;
932: l_other_manager_warning boolean;

Line 929: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

925: -- Out variables
926: --
927: l_comment_id per_all_assignments_f.comment_id%TYPE;
928: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
929: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
930: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
931: l_no_managers_warning boolean;
932: l_other_manager_warning boolean;
933: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 930: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

926: --
927: l_comment_id per_all_assignments_f.comment_id%TYPE;
928: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
929: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
930: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
931: l_no_managers_warning boolean;
932: l_other_manager_warning boolean;
933: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
934: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 933: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

929: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
930: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
931: l_no_managers_warning boolean;
932: l_other_manager_warning boolean;
933: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
934: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
935: l_effective_date date;
936: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
937: --

Line 936: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

932: l_other_manager_warning boolean;
933: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
934: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
935: l_effective_date date;
936: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
937: --
938: -- Internal working variables
939: --
940: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 940: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

936: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
937: --
938: -- Internal working variables
939: --
940: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
941: l_business_group_id per_business_groups.business_group_id%TYPE;
942: l_person_id number;
943: l_assignment_extra_info_id number;
944: l_assignment_extra_info_ovn number;

Line 946: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

942: l_person_id number;
943: l_assignment_extra_info_id number;
944: l_assignment_extra_info_ovn number;
945: l_payroll_id_updated boolean;
946: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
947: l_org_now_no_manager_warning boolean;
948: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
949: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
950: l_entries_changed varchar2(100);

Line 948: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

944: l_assignment_extra_info_ovn number;
945: l_payroll_id_updated boolean;
946: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
947: l_org_now_no_manager_warning boolean;
948: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
949: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
950: l_entries_changed varchar2(100);
951: l_age number;
952: l_adj_serv_date date;

Line 949: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

945: l_payroll_id_updated boolean;
946: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
947: l_org_now_no_manager_warning boolean;
948: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
949: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
950: l_entries_changed varchar2(100);
951: l_age number;
952: l_adj_serv_date date;
953: l_orig_hire_date date;

Line 977: from per_all_assignments_f asg

973: select asg.assignment_type
974: , asg.business_group_id
975: , asg.soft_coding_keyflex_id
976: , asg.payroll_id
977: from per_all_assignments_f asg
978: where asg.assignment_id = c_assignment_id
979: and asg.assignment_type = 'B'
980: and c_eff_date between asg.effective_start_date
981: and asg.effective_end_date;

Line 1565: from per_all_assignments_f asg,

1561: )
1562: Is
1563: select ptu.person_type_usage_id,
1564: ptu.object_version_number
1565: from per_all_assignments_f asg,
1566: per_person_type_usages_f ptu,
1567: per_person_types pet
1568: where ptu.person_id = asg.person_id
1569: and asg.assignment_type <> 'C'

Line 1619: from per_all_assignments_f asg

1615: hr_utility.set_location('Entering:'|| l_proc, 10);
1616: begin
1617: select asg.business_group_id
1618: into l_business_group_id
1619: from per_all_assignments_f asg
1620: where asg.assignment_id = p_assignment_id
1621: and asg.assignment_type <> 'C'
1622: and p_effective_date between asg.effective_start_date
1623: and asg.effective_end_date;

Line 1660: from per_all_assignments_f asg

1656: --
1657: delete from per_person_type_usages_f ptu
1658: where ptu.person_id in
1659: (select asg.person_id
1660: from per_all_assignments_f asg
1661: where asg.assignment_id = p_assignment_id
1662: )
1663: and ptu.person_type_id in
1664: (select pet.person_type_id