77: )
78: return NUMBER is
79: cursor csr_get_id_flex_num is
80: SELECT id_flex_num
81: FROM FND_ID_FLEX_STRUCTURES_VL
82: WHERE (ID_FLEX_STRUCTURE_CODE = 'AE_STATUTORY_INFO')
83: and (APPLICATION_ID=800)
84: and (ID_FLEX_CODE='SCL') ;
85: cursor csr_get_formula_id ( p_id_flex_num number) is
105: l_formula_id NUMBER;
106: l_inputs ff_exec.inputs_t;
107: l_outputs ff_exec.outputs_t;
108: l_value NUMBER;
109: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
110: begin
111: open csr_get_id_flex_num;
112: fetch csr_get_id_flex_num into l_id_flex_num;
113: close csr_get_id_flex_num;