APPS.HR_FLEXFIELD_INFO dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 1753: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE

1749: -- |-------------------< get_kf_concatenated_structures >---------------------|
1750: -- ----------------------------------------------------------------------------
1751: PROCEDURE get_kf_concatenated_structures
1752: (p_appl_short_name IN fnd_application.application_short_name%TYPE
1753: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE
1754: ,p_enabled_only IN BOOLEAN
1755: ,p_concatenation_chr IN VARCHAR2
1756: ,p_structure_list OUT NOCOPY LONG
1757: ) is

Line 1838: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE

1834: -- ----------------------------------------------------------------------------
1835: --
1836: PROCEDURE get_kf_segments
1837: (p_appl_short_name IN fnd_application.application_short_name%TYPE
1838: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE
1839: ,p_id_flex_structure_name IN
1840: fnd_id_flex_structures_vl.id_flex_structure_name%TYPE
1841: ,p_enabled_only IN BOOLEAN
1842: ,p_segments OUT NOCOPY hr_segments_info

Line 1840: fnd_id_flex_structures_vl.id_flex_structure_name%TYPE

1836: PROCEDURE get_kf_segments
1837: (p_appl_short_name IN fnd_application.application_short_name%TYPE
1838: ,p_id_flex_code IN fnd_id_flex_structures_vl.id_flex_code%TYPE
1839: ,p_id_flex_structure_name IN
1840: fnd_id_flex_structures_vl.id_flex_structure_name%TYPE
1841: ,p_enabled_only IN BOOLEAN
1842: ,p_segments OUT NOCOPY hr_segments_info
1843: ,p_session_date IN DATE
1844: ) is

Line 1897: FROM fnd_id_flex_structures_vl

1893: */
1894: -- fix for bug 1259164
1895: SELECT id_flex_structure_code
1896: INTO l_structure_code
1897: FROM fnd_id_flex_structures_vl
1898: WHERE application_id = l_flexfield.application_id
1899: AND id_flex_code = l_flexfield.flex_code
1900: AND id_flex_structure_name = p_id_flex_structure_name;
1901: