APPS.IGS_AD_IMP_PRBLTY_VAL_PKG dependencies on IGS_AD_CODE_CLASSES

Line 71: FROM igs_ad_code_classes iacc

67: || (reverse chronological order - newest change first)
68: */
69: CURSOR prblty_type_val_check_cur IS
70: SELECT 'X'
71: FROM igs_ad_code_classes iacc
72: WHERE iacc.code_id = prblty_val_rec.prblty_type_code_id AND
73: iacc.class = 'PROB_TYPE';
74:
75: CURSOR prblty_source_val_check_cur IS

Line 77: FROM igs_ad_code_classes iacc

73: iacc.class = 'PROB_TYPE';
74:
75: CURSOR prblty_source_val_check_cur IS
76: SELECT 'X'
77: FROM igs_ad_code_classes iacc
78: WHERE iacc.code_id = prblty_val_rec.prblty_source_code_id AND
79: iacc.class = 'PROB_SOURCE';
80:
81: l_validity_check VARCHAR2(1);