APPS.HR_AU_TAX_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 201: from per_all_assignments_f asg

197: (p_assignment_id number
198: ,p_effective_date date
199: ) is
200: select scl.segment2
201: from per_all_assignments_f asg
202: , hr_soft_coding_keyflex scl
203: where scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
204: and asg.effective_start_date <= p_effective_date
205: and asg.effective_end_date >= p_effective_date

Line 1701: l_effective_start_date per_all_assignments_f.effective_start_date%type;

1697: and sysdate between effective_start_date and effective_end_date;
1698: --
1699: l_procedure varchar2(100) := g_package||'update_adi_tax_crp';
1700: --
1701: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1702: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1703: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1704: l_element_type_id pay_element_types_f.element_type_id%type;
1705: l_element_link_id pay_element_links_f.element_link_id%type;

Line 1702: l_effective_end_date per_all_assignments_f.effective_end_date%type;

1698: --
1699: l_procedure varchar2(100) := g_package||'update_adi_tax_crp';
1700: --
1701: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1702: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1703: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1704: l_element_type_id pay_element_types_f.element_type_id%type;
1705: l_element_link_id pay_element_links_f.element_link_id%type;
1706: l_object_version_number per_all_assignments_f.object_version_number%type;

Line 1706: l_object_version_number per_all_assignments_f.object_version_number%type;

1702: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1703: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1704: l_element_type_id pay_element_types_f.element_type_id%type;
1705: l_element_link_id pay_element_links_f.element_link_id%type;
1706: l_object_version_number per_all_assignments_f.object_version_number%type;
1707: l_create_warning boolean;
1708: l_update_warning boolean;
1709: l_cagr_grade_def_id number;
1710: l_cagr_concatenated_segments varchar2(2000);

Line 1712: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;

1708: l_update_warning boolean;
1709: l_cagr_grade_def_id number;
1710: l_cagr_concatenated_segments varchar2(2000);
1711: l_comment_id number;
1712: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
1713: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1714: l_no_managers_warning boolean;
1715: l_other_manager_warning boolean;
1716: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;

Line 1716: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;

1712: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
1713: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1714: l_no_managers_warning boolean;
1715: l_other_manager_warning boolean;
1716: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1717: l_people_group_id per_all_assignments_f.people_group_id%type;
1718: l_group_name pay_people_groups.group_name%type;
1719: l_org_now_no_manager_warning boolean;
1720: l_spp_delete_warning boolean;

Line 1717: l_people_group_id per_all_assignments_f.people_group_id%type;

1713: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1714: l_no_managers_warning boolean;
1715: l_other_manager_warning boolean;
1716: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1717: l_people_group_id per_all_assignments_f.people_group_id%type;
1718: l_group_name pay_people_groups.group_name%type;
1719: l_org_now_no_manager_warning boolean;
1720: l_spp_delete_warning boolean;
1721: l_entries_changed_warning varchar2(1);