APPS.IGS_AD_GEN_005 dependencies on IGS_CO_CAT

Line 56: FROM IGS_CO_CAT_MAP ccm,

52: DECLARE
53: CURSOR c_ccm IS
54: SELECT ccm.correspondence_cat,
55: cc.description
56: FROM IGS_CO_CAT_MAP ccm,
57: IGS_CO_CAT cc
58: WHERE ccm.admission_cat = p_admission_cat AND
59: ccm.dflt_cat_ind = 'Y' AND
60: cc.correspondence_cat = ccm.correspondence_cat AND

Line 57: IGS_CO_CAT cc

53: CURSOR c_ccm IS
54: SELECT ccm.correspondence_cat,
55: cc.description
56: FROM IGS_CO_CAT_MAP ccm,
57: IGS_CO_CAT cc
58: WHERE ccm.admission_cat = p_admission_cat AND
59: ccm.dflt_cat_ind = 'Y' AND
60: cc.correspondence_cat = ccm.correspondence_cat AND
61: cc.closed_ind = 'N';

Line 63: v_correspondence_cat IGS_CO_CAT_MAP.correspondence_cat%TYPE

59: ccm.dflt_cat_ind = 'Y' AND
60: cc.correspondence_cat = ccm.correspondence_cat AND
61: cc.closed_ind = 'N';
62: v_ccm_rec c_ccm%ROWTYPE;
63: v_correspondence_cat IGS_CO_CAT_MAP.correspondence_cat%TYPE
64: DEFAULT NULL;
65: BEGIN
66: -- get the correspondence_cat record and check for Multiple Rows
67: FOR v_ccm_rec IN c_ccm LOOP