APPS.IGS_FI_CRDAPI_UTIL dependencies on IGS_LOOKUP_VALUES

Line 836: CURSOR cur_igs_lkp (cp_lookup_code igs_lookup_values.lookup_code%TYPE,

832: Known limitations,enhancements,remarks:
833: Change History
834: Who When What
835: ********************************************************************************************** */
836: CURSOR cur_igs_lkp (cp_lookup_code igs_lookup_values.lookup_code%TYPE,
837: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
838: cp_enabled_flag VARCHAR2)
839: IS
840: SELECT 'x'

Line 837: cp_lookup_type igs_lookup_values.lookup_type%TYPE,

833: Change History
834: Who When What
835: ********************************************************************************************** */
836: CURSOR cur_igs_lkp (cp_lookup_code igs_lookup_values.lookup_code%TYPE,
837: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
838: cp_enabled_flag VARCHAR2)
839: IS
840: SELECT 'x'
841: FROM igs_lookup_values

Line 841: FROM igs_lookup_values

837: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
838: cp_enabled_flag VARCHAR2)
839: IS
840: SELECT 'x'
841: FROM igs_lookup_values
842: WHERE lookup_type = cp_lookup_type
843: AND lookup_code = cp_lookup_code
844: AND enabled_flag = cp_enabled_flag
845: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE, SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE, SYSDATE));