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 142: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

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

Line 191: from per_all_assignments_f asg,

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

Line 900: l_comment_id per_all_assignments_f.comment_id%TYPE;

896: --
897: l_proc varchar2(72) := g_package||'update_ben_asg';
898: -- Out variables
899: --
900: l_comment_id per_all_assignments_f.comment_id%TYPE;
901: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
902: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
903: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
904: l_no_managers_warning boolean;

Line 901: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;

897: l_proc varchar2(72) := g_package||'update_ben_asg';
898: -- Out variables
899: --
900: l_comment_id per_all_assignments_f.comment_id%TYPE;
901: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
902: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
903: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
904: l_no_managers_warning boolean;
905: l_other_manager_warning boolean;

Line 902: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;

898: -- Out variables
899: --
900: l_comment_id per_all_assignments_f.comment_id%TYPE;
901: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
902: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
903: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
904: l_no_managers_warning boolean;
905: l_other_manager_warning boolean;
906: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

Line 903: l_object_version_number per_all_assignments_f.object_version_number%TYPE;

899: --
900: l_comment_id per_all_assignments_f.comment_id%TYPE;
901: l_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
902: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
903: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
904: l_no_managers_warning boolean;
905: l_other_manager_warning boolean;
906: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
907: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 906: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

902: l_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
903: l_object_version_number per_all_assignments_f.object_version_number%TYPE;
904: l_no_managers_warning boolean;
905: l_other_manager_warning boolean;
906: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
907: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
908: l_effective_date date;
909: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
910: --

Line 909: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;

905: l_other_manager_warning boolean;
906: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
907: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
908: l_effective_date date;
909: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
910: --
911: -- Internal working variables
912: --
913: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 913: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

909: l_date_probation_end per_all_assignments_f.date_probation_end%TYPE;
910: --
911: -- Internal working variables
912: --
913: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
914: l_business_group_id per_business_groups.business_group_id%TYPE;
915: l_person_id number;
916: l_assignment_extra_info_id number;
917: l_assignment_extra_info_ovn number;

Line 919: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

915: l_person_id number;
916: l_assignment_extra_info_id number;
917: l_assignment_extra_info_ovn number;
918: l_payroll_id_updated boolean;
919: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
920: l_org_now_no_manager_warning boolean;
921: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
922: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
923: l_entries_changed varchar2(100);

Line 921: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;

917: l_assignment_extra_info_ovn number;
918: l_payroll_id_updated boolean;
919: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
920: l_org_now_no_manager_warning boolean;
921: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
922: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
923: l_entries_changed varchar2(100);
924: l_age number;
925: l_adj_serv_date date;

Line 922: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;

918: l_payroll_id_updated boolean;
919: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
920: l_org_now_no_manager_warning boolean;
921: l_validation_start_date per_all_assignments_f.effective_start_date%TYPE;
922: l_validation_end_date per_all_assignments_f.effective_end_date%TYPE;
923: l_entries_changed varchar2(100);
924: l_age number;
925: l_adj_serv_date date;
926: l_orig_hire_date date;

Line 950: from per_all_assignments_f asg

946: select asg.assignment_type
947: , asg.business_group_id
948: , asg.soft_coding_keyflex_id
949: , asg.payroll_id
950: from per_all_assignments_f asg
951: where asg.assignment_id = c_assignment_id
952: and asg.assignment_type = 'B'
953: and c_eff_date between asg.effective_start_date
954: and asg.effective_end_date;

Line 1537: from per_all_assignments_f asg,

1533: )
1534: Is
1535: select ptu.person_type_usage_id,
1536: ptu.object_version_number
1537: from per_all_assignments_f asg,
1538: per_person_type_usages_f ptu,
1539: per_person_types pet
1540: where ptu.person_id = asg.person_id
1541: and asg.assignment_type <> 'C'

Line 1591: from per_all_assignments_f asg

1587: hr_utility.set_location('Entering:'|| l_proc, 10);
1588: begin
1589: select asg.business_group_id
1590: into l_business_group_id
1591: from per_all_assignments_f asg
1592: where asg.assignment_id = p_assignment_id
1593: and asg.assignment_type <> 'C'
1594: and p_effective_date between asg.effective_start_date
1595: and asg.effective_end_date;

Line 1632: from per_all_assignments_f asg

1628: --
1629: delete from per_person_type_usages_f ptu
1630: where ptu.person_id in
1631: (select asg.person_id
1632: from per_all_assignments_f asg
1633: where asg.assignment_id = p_assignment_id
1634: )
1635: and ptu.person_type_id in
1636: (select pet.person_type_id