APPS.IGS_PS_VAL_CEPRC dependencies on IGS_PS_OFR_OPT

Line 85: FROM IGS_PS_OFR_UNIT_SET cous,IGS_PS_OFR_OPT coo,igs_en_unit_set_stat uss1,IGS_EN_UNIT_SET_ALL US

81: cst_true CONSTANT VARCHAR2(5) := 'TRUE';
82: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
83: CURSOR c_uss IS
84: SELECT 'X'
85: FROM IGS_PS_OFR_UNIT_SET cous,IGS_PS_OFR_OPT coo,igs_en_unit_set_stat uss1,IGS_EN_UNIT_SET_ALL US
86: WHERE coo.coo_id = p_coo_id
87: AND us.version_number = p_us_version_number
88: AND us.unit_set_cd = p_unit_set_cd
89: AND us.expiry_dt IS NULL