75: P_MODE IN VARCHAR2 DEFAULT 'CP')
76: IS
77:
78: CURSOR c_get_level IS
79: SELECT PREFERENCE_VALUE FROM IEX_APP_PREFERENCES_VL WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';
80:
81: CURSOR c_get_table IS
82: select OWNER || '.' || TABLE_NAME from sys.all_tables where table_name = 'IEX_DLN_UWQ_SUMMARY';
83:
7071: FROM_DATE IN VARCHAR2,
7072: P_MODE IN VARCHAR2 DEFAULT 'CP') is
7073: l_level varchar2(20);
7074: CURSOR c_get_level IS
7075: SELECT PREFERENCE_VALUE FROM IEX_APP_PREFERENCES_VL WHERE PREFERENCE_NAME = 'COLLECTIONS STRATEGY LEVEL';
7076: BEGIN
7077: OPEN c_get_level;
7078: FETCH c_get_level INTO l_level;
7079: CLOSE c_get_level;