APPS.HR_ASSIGNMENT_ISETUP_SWI dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1728: l_tax_unit_id hr_all_organization_units.organization_id%type;

1724: ,p_scl_concat_segments in varchar2) RETURN NUMBER AS
1725: --
1726: l_scl_keyflex_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
1727: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;
1728: l_tax_unit_id hr_all_organization_units.organization_id%type;
1729: --
1730: --
1731: begin
1732: --

Line 1741: FROM hr_all_organization_units

1737: WHERE id_flex_structure_code = p_scl_flex_struc_code
1738: AND application_id = 800;
1739:
1740: SELECT organization_id INTO l_tax_unit_id
1741: FROM hr_all_organization_units
1742: WHERE name = p_tax_unit_name
1743: AND business_group_id = p_bg_id;
1744: --
1745: begin