75: return NUMBER is
76:
77: cursor csr_get_id_flex_num is
78: SELECT id_flex_num
79: FROM FND_ID_FLEX_STRUCTURES_VL
80: WHERE (ID_FLEX_STRUCTURE_CODE = 'KW_STATUTORY_INFO')
81: and (APPLICATION_ID=800)
82: and (ID_FLEX_CODE='SCL') ;
83:
104: l_formula_id NUMBER;
105: l_inputs ff_exec.inputs_t;
106: l_outputs ff_exec.outputs_t;
107: l_value NUMBER;
108: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
109:
110: begin
111:
112: open csr_get_id_flex_num;