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;

Line 182: FROM FND_ID_FLEX_STRUCTURES_VL

178: )
179: return NUMBER is
180: cursor csr_get_id_flex_num is
181: SELECT id_flex_num
182: FROM FND_ID_FLEX_STRUCTURES_VL
183: WHERE (ID_FLEX_STRUCTURE_CODE = 'AE_STATUTORY_INFO')
184: and (APPLICATION_ID=800)
185: and (ID_FLEX_CODE='SCL') ;
186: cursor csr_get_formula_id ( p_id_flex_num number) is

Line 210: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;

206: l_formula_id NUMBER;
207: l_inputs ff_exec.inputs_t;
208: l_outputs ff_exec.outputs_t;
209: l_value NUMBER;
210: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
211: begin
212: open csr_get_id_flex_num;
213: fetch csr_get_id_flex_num into l_id_flex_num;
214: close csr_get_id_flex_num;

Line 285: FROM FND_ID_FLEX_STRUCTURES_VL

281: )
282: return NUMBER is
283: cursor csr_get_id_flex_num is
284: SELECT id_flex_num
285: FROM FND_ID_FLEX_STRUCTURES_VL
286: WHERE (ID_FLEX_STRUCTURE_CODE = 'AE_STATUTORY_INFO')
287: and (APPLICATION_ID=800)
288: and (ID_FLEX_CODE='SCL') ;
289: cursor csr_get_formula_id ( p_id_flex_num number) is

Line 313: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;

309: l_formula_id NUMBER;
310: l_inputs ff_exec.inputs_t;
311: l_outputs ff_exec.outputs_t;
312: l_value NUMBER;
313: l_id_flex_num FND_ID_FLEX_STRUCTURES_VL.id_flex_num %type;
314: begin
315: hr_utility.set_location('Inside run_SA_GOSI_formula',10);
316: hr_utility.set_location('p_assignment_id' || p_assignment_id ,10);
317: hr_utility.set_location('p_date_earned'|| fnd_date.date_to_canonical(p_date_earned) ,10);