APPS.IGF_SL_GEN dependencies on IGF_LOOKUPS_VIEW

Line 125: SELECT 'x' FROM igf_lookups_view

121: ***************************************************************/
122:
123: l_temp VARCHAR2(10);
124: CURSOR c1 IS
125: SELECT 'x' FROM igf_lookups_view
126: WHERE lookup_type = 'IGF_SL_DL_STAFFORD'
127: AND lookup_code = UPPER(p_fed_fund_code)
128: AND enabled_flag = 'Y';
129: BEGIN

Line 159: SELECT 'x' FROM igf_lookups_view

155: ***************************************************************/
156:
157: l_temp VARCHAR2(10);
158: CURSOR c1 IS
159: SELECT 'x' FROM igf_lookups_view
160: WHERE lookup_type = 'IGF_SL_DL_PLUS'
161: AND lookup_code = UPPER(p_fed_fund_code)
162: AND enabled_flag = 'Y';
163: BEGIN

Line 217: SELECT 'x' FROM igf_lookups_view

213: ***************************************************************/
214:
215: l_temp VARCHAR2(10);
216: CURSOR c1 IS
217: SELECT 'x' FROM igf_lookups_view
218: WHERE lookup_type = 'IGF_SL_CL_GPLUS'
219: AND lookup_code = UPPER(p_fed_fund_code)
220: AND enabled_flag = 'Y';
221: BEGIN

Line 249: SELECT 'x' FROM igf_lookups_view

245: ***************************************************************/
246:
247: l_temp VARCHAR2(10);
248: CURSOR c1 IS
249: SELECT 'x' FROM igf_lookups_view
250: WHERE lookup_type = 'IGF_SL_CL_STAFFORD'
251: AND lookup_code = UPPER(p_fed_fund_code)
252: AND enabled_flag = 'Y';
253: BEGIN

Line 283: SELECT 'x' FROM igf_lookups_view

279: ***************************************************************/
280:
281: l_temp VARCHAR2(10);
282: CURSOR c1 IS
283: SELECT 'x' FROM igf_lookups_view
284: WHERE lookup_type = 'IGF_SL_CL_PLUS'
285: AND lookup_code = UPPER(p_fed_fund_code)
286: AND enabled_flag = 'Y';
287: BEGIN