DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_EN_UNIT_SET_STAT

Line 2548: FROM igs_en_unit_set us, igs_en_unit_set_stat uss

2544:
2545: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2546: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2547: SELECT 'X'
2548: FROM igs_en_unit_set us, igs_en_unit_set_stat uss
2549: WHERE us.unit_set_status = uss.unit_set_status
2550: AND uss.s_unit_set_status <> 'INACTIVE'
2551: AND us.unit_set_cd = cp_preference_code
2552: AND us.version_number = cp_preference_version;

Line 2697: FROM igs_en_unit_set us, igs_en_unit_set_stat uss

2693:
2694: CURSOR c_unit_set(cp_preference_code igs_ps_rsv_usec_prf.preference_code%TYPE,
2695: cp_preference_version igs_ps_rsv_usec_prf.preference_version%TYPE) IS
2696: SELECT 'X'
2697: FROM igs_en_unit_set us, igs_en_unit_set_stat uss
2698: WHERE us.unit_set_status = uss.unit_set_status
2699: AND uss.s_unit_set_status <> 'INACTIVE'
2700: AND us.unit_set_cd = cp_preference_code
2701: AND us.version_number = cp_preference_version;