APPS.HR_AU_TAX_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 189: from per_all_assignments_f asg

185: (p_assignment_id number
186: ,p_effective_date date
187: ) is
188: select scl.segment2
189: from per_all_assignments_f asg
190: , hr_soft_coding_keyflex scl
191: where scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
192: and asg.effective_start_date <= p_effective_date
193: and asg.effective_end_date >= p_effective_date

Line 1659: l_effective_start_date per_all_assignments_f.effective_start_date%type;

1655: and p_hire_date between effective_start_date and effective_end_date;
1656: --
1657: l_procedure varchar2(100) := g_package||'update_adi_tax_crp';
1658: --
1659: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1660: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1661: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1662: l_element_type_id pay_element_types_f.element_type_id%type;
1663: l_element_link_id pay_element_links_f.element_link_id%type;

Line 1660: l_effective_end_date per_all_assignments_f.effective_end_date%type;

1656: --
1657: l_procedure varchar2(100) := g_package||'update_adi_tax_crp';
1658: --
1659: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1660: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1661: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1662: l_element_type_id pay_element_types_f.element_type_id%type;
1663: l_element_link_id pay_element_links_f.element_link_id%type;
1664: l_object_version_number per_all_assignments_f.object_version_number%type;

Line 1664: l_object_version_number per_all_assignments_f.object_version_number%type;

1660: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1661: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1662: l_element_type_id pay_element_types_f.element_type_id%type;
1663: l_element_link_id pay_element_links_f.element_link_id%type;
1664: l_object_version_number per_all_assignments_f.object_version_number%type;
1665: l_create_warning boolean;
1666: l_update_warning boolean;
1667: l_cagr_grade_def_id number;
1668: l_cagr_concatenated_segments varchar2(2000);

Line 1670: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;

1666: l_update_warning boolean;
1667: l_cagr_grade_def_id number;
1668: l_cagr_concatenated_segments varchar2(2000);
1669: l_comment_id number;
1670: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
1671: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1672: l_no_managers_warning boolean;
1673: l_other_manager_warning boolean;
1674: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;

Line 1674: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;

1670: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type;
1671: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1672: l_no_managers_warning boolean;
1673: l_other_manager_warning boolean;
1674: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1675: l_people_group_id per_all_assignments_f.people_group_id%type;
1676: l_group_name pay_people_groups.group_name%type;
1677: l_org_now_no_manager_warning boolean;
1678: l_spp_delete_warning boolean;

Line 1675: l_people_group_id per_all_assignments_f.people_group_id%type;

1671: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1672: l_no_managers_warning boolean;
1673: l_other_manager_warning boolean;
1674: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%type;
1675: l_people_group_id per_all_assignments_f.people_group_id%type;
1676: l_group_name pay_people_groups.group_name%type;
1677: l_org_now_no_manager_warning boolean;
1678: l_spp_delete_warning boolean;
1679: l_entries_changed_warning varchar2(1);