APPS.HR_ASSIGNMENT_ISETUP_SWI dependencies on FND_ID_FLEX_STRUCTURES

Line 1727: l_id_flex_num fnd_id_flex_structures.id_flex_num%type;

1723: ,p_scl_flex_struc_code in varchar2
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

Line 1736: FROM fnd_id_flex_structures

1732: --
1733: --
1734: if p_tax_unit_name is not null then
1735: SELECT id_flex_num INTO l_id_flex_num
1736: FROM fnd_id_flex_structures
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