DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on FND_ID_FLEX_STRUCTURES

Line 112: FROM fnd_id_flex_structures

108: FUNCTION get_kf_id_flex_num(p_id_flex_code Varchar2,
109: p_structure_code VARCHAR2) RETURN NUMBER IS
110: Cursor C_Id_Flex IS
111: SELECT id_flex_num
112: FROM fnd_id_flex_structures
113: WHERE id_flex_code = p_id_flex_code
114: AND id_flex_structure_code = p_structure_code;
115:
116: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;

Line 116: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;

112: FROM fnd_id_flex_structures
113: WHERE id_flex_code = p_id_flex_code
114: AND id_flex_structure_code = p_structure_code;
115:
116: l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE;
117: BEGIN
118: OPEN C_Id_Flex;
119: FETCH C_Id_Flex INTO l_id_flex_num;
120: IF C_Id_Flex%NOTFOUND THEN