APPS.IGS_AD_IMP_002 dependencies on IGS_AD_CODE_CLASSES

Line 24: CURSOR level_of_qual_cur(cp_class igs_ad_code_classes.class%TYPE,

20: || Who When What
21: */
22:
23: -- Cursor to check veteran
24: CURSOR level_of_qual_cur(cp_class igs_ad_code_classes.class%TYPE,
25: cp_code_id igs_ad_code_classes.code_id%TYPE,
26: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE)IS
27: SELECT 'X'
28: FROM igs_ad_code_classes

Line 25: cp_code_id igs_ad_code_classes.code_id%TYPE,

21: */
22:
23: -- Cursor to check veteran
24: CURSOR level_of_qual_cur(cp_class igs_ad_code_classes.class%TYPE,
25: cp_code_id igs_ad_code_classes.code_id%TYPE,
26: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE)IS
27: SELECT 'X'
28: FROM igs_ad_code_classes
29: WHERE class = cp_class

Line 26: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE)IS

22:
23: -- Cursor to check veteran
24: CURSOR level_of_qual_cur(cp_class igs_ad_code_classes.class%TYPE,
25: cp_code_id igs_ad_code_classes.code_id%TYPE,
26: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE)IS
27: SELECT 'X'
28: FROM igs_ad_code_classes
29: WHERE class = cp_class
30: AND code_id = cp_code_id

Line 28: FROM igs_ad_code_classes

24: CURSOR level_of_qual_cur(cp_class igs_ad_code_classes.class%TYPE,
25: cp_code_id igs_ad_code_classes.code_id%TYPE,
26: cp_closed_ind igs_ad_code_classes.closed_ind%TYPE)IS
27: SELECT 'X'
28: FROM igs_ad_code_classes
29: WHERE class = cp_class
30: AND code_id = cp_code_id
31: AND closed_ind = cp_closed_ind;
32: