DBA Data[Home] [Help]

APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_LOOKUP_VALUES

Line 147: FROM igs_lookup_values

143: -- Cursor for validation of the Balance Type
144: -- This cursor has been changed to exclude INSTALLMENT and OTHER balance types as part of Enh# 2562745.
145: CURSOR cur_balance_lkup_type(cp_balance_type IN VARCHAR2) IS
146: SELECT meaning
147: FROM igs_lookup_values
148: WHERE lookup_type = g_lookup_type
149: AND lookup_code = cp_balance_type
150: AND lookup_code NOT IN ('STANDARD', 'INSTALLMENT', 'OTHER')
151: AND sysdate BETWEEN NVL(start_date_active, sysdate) AND