APPS.IGS_CA_INST_REL_PKG dependencies on IGS_CA_TYPE

Line 92: l_c_sup_cat igs_ca_type.s_cal_cat%TYPE;

88: Enhancement Bug No. 2191470
89: ******************************************************************/
90: cst_load CONSTANT VARCHAR2(10):= 'LOAD';
91: cst_fee CONSTANT VARCHAR2(10):= 'FEE';
92: l_c_sup_cat igs_ca_type.s_cal_cat%TYPE;
93:
94: CURSOR c_cat(cp_cal_type IN igs_ca_type.cal_type%TYPE) IS
95: SELECT s_cal_cat
96: FROM igs_ca_type

Line 94: CURSOR c_cat(cp_cal_type IN igs_ca_type.cal_type%TYPE) IS

90: cst_load CONSTANT VARCHAR2(10):= 'LOAD';
91: cst_fee CONSTANT VARCHAR2(10):= 'FEE';
92: l_c_sup_cat igs_ca_type.s_cal_cat%TYPE;
93:
94: CURSOR c_cat(cp_cal_type IN igs_ca_type.cal_type%TYPE) IS
95: SELECT s_cal_cat
96: FROM igs_ca_type
97: WHERE cal_type = cp_cal_type;
98:

Line 96: FROM igs_ca_type

92: l_c_sup_cat igs_ca_type.s_cal_cat%TYPE;
93:
94: CURSOR c_cat(cp_cal_type IN igs_ca_type.cal_type%TYPE) IS
95: SELECT s_cal_cat
96: FROM igs_ca_type
97: WHERE cal_type = cp_cal_type;
98:
99: CURSOR c_fci_lci(cp_sup_cal_type IN igs_ca_inst.cal_type%TYPE,
100: cp_sup_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE,

Line 105: igs_ca_type ct1,

101: cp_sub_cal_type IN igs_ca_inst.cal_type%TYPE,
102: cp_sub_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
103: SELECT 'x'
104: FROM igs_ca_inst_rel cir,
105: igs_ca_type ct1,
106: igs_ca_type ct2
107: WHERE cir.sub_cal_type = ct1.cal_type
108: AND ct1.s_cal_cat = cst_load
109: AND cir.sup_cal_type = ct2.cal_type

Line 106: igs_ca_type ct2

102: cp_sub_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
103: SELECT 'x'
104: FROM igs_ca_inst_rel cir,
105: igs_ca_type ct1,
106: igs_ca_type ct2
107: WHERE cir.sub_cal_type = ct1.cal_type
108: AND ct1.s_cal_cat = cst_load
109: AND cir.sup_cal_type = ct2.cal_type
110: AND ct2.s_cal_cat = cst_fee

Line 192: igs_ca_type b ,

188: RETURN BOOLEAN AS
189: CURSOR c_acad_adm_rel IS
190: SELECT 'X'
191: FROM igs_ca_inst_rel a ,
192: igs_ca_type b ,
193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,
196: igs_ca_stat f,

Line 193: igs_ca_type c ,

189: CURSOR c_acad_adm_rel IS
190: SELECT 'X'
191: FROM igs_ca_inst_rel a ,
192: igs_ca_type b ,
193: igs_ca_type c ,
194: igs_ca_inst d ,
195: igs_ca_inst e ,
196: igs_ca_stat f,
197: igs_ca_stat g