6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS
8: CURSOR FND_CURSOR IS
9: SELECT LOOKUP_TYPE,LOOKUP_CODE, MEANING
10: FROM FND_LOOKUPS
11: WHERE LOOKUP_TYPE IN ('YES_NO', 'IBE_BI_GENERIC')
12: ORDER BY LOOKUP_TYPE, LOOKUP_CODE;
13:
14: l_custom_sql VARCHAR2(4000);
292: x_custom_sql OUT NOCOPY VARCHAR2,
293: x_custom_output OUT NOCOPY bis_query_attributes_TBL ) IS
294: CURSOR FND_CURSOR IS
295: SELECT LOOKUP_TYPE,LOOKUP_CODE, MEANING
296: FROM FND_LOOKUPS
297: WHERE LOOKUP_TYPE IN ('YES_NO', 'IBE_BI_GENERIC')
298: ORDER BY LOOKUP_TYPE, LOOKUP_CODE;
299:
300: l_custom_sql VARCHAR2(4000);