APPS.IGS_EN_SPI_RCOND_LGCY_PUB dependencies on IGS_LOOKUP_VALUES

Line 66: FROM igs_lookup_values

62: ***********************************************************************************************/
63:
64: CURSOR chk_rcond_status IS
65: SELECT 'x'
66: FROM igs_lookup_values
67: WHERE lookup_type = 'IGS_EN_INTM_RCOND_STS'
68: AND lookup_Code = p_intm_rcond_rec.status_code;
69:
70: CURSOR chk_intermission (cp_person_id hz_parties.party_id%TYPE) IS