APPS.IGR_IMP_003 dependencies on IGS_AD_CODE_CLASSES

Line 496: igs_ad_code_classes cc

492: CURSOR c_edu_goal_id (cp_edu_goal_id igr_i_appl_int.edu_goal_id%TYPE) IS
493: SELECT
494: 'X'
495: FROM
496: igs_ad_code_classes cc
497: WHERE
498: cc.class = 'EDU_GOALS'
499: AND NVL(cc.closed_ind,'N') = 'N'
500: AND cc.code_id = cp_edu_goal_id;

Line 517: igs_ad_code_classes cc

513: CURSOR c_learn_source_id (cp_learn_source_id igr_i_appl_int.learn_source_id%TYPE) IS
514: SELECT
515: 'X'
516: FROM
517: igs_ad_code_classes cc
518: WHERE
519: cc.class = 'INQ_HOW_KNOWUS'
520: AND NVL(cc.closed_ind,'N') = 'N'
521: AND cc.code_id = cp_learn_source_id;

Line 529: igs_ad_code_classes cc

525: CURSOR c_influence_source_id (cp_influence_source_id igr_i_appl_int.influence_source_id%TYPE) IS
526: SELECT
527: 'X'
528: FROM
529: igs_ad_code_classes cc
530: WHERE
531: cc.class = 'INQ_WHO_INFLUENCED'
532: AND NVL(cc.closed_ind,'N') = 'N'
533: AND cc.code_id = cp_influence_source_id;