DBA Data[Home] [Help]

APPS.PAY_AE_USER_FUNCTION dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 81: FROM FND_ID_FLEX_STRUCTURES_VL

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

Line 109: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;

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;