APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_CA_TYPE

Line 9423: cp_v_admission igs_ca_type.s_cal_cat%TYPE,

9419:
9420: -- Cursor to Get the subordinate Load Calendar Instance for the derived Admission Calendar Instance
9421: CURSOR c_sub_adm_cal ( cp_v_adm_cal_type igs_ca_inst_all.cal_type%TYPE,
9422: cp_n_adm_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
9423: cp_v_admission igs_ca_type.s_cal_cat%TYPE,
9424: cp_v_load igs_ca_type.s_cal_cat%TYPE ) IS
9425: SELECT rl.sub_cal_type,
9426: rl.sub_ci_sequence_number
9427: FROM igs_ca_inst_rel rl,

Line 9424: cp_v_load igs_ca_type.s_cal_cat%TYPE ) IS

9420: -- Cursor to Get the subordinate Load Calendar Instance for the derived Admission Calendar Instance
9421: CURSOR c_sub_adm_cal ( cp_v_adm_cal_type igs_ca_inst_all.cal_type%TYPE,
9422: cp_n_adm_ci_seq_num igs_ca_inst_all.sequence_number%TYPE,
9423: cp_v_admission igs_ca_type.s_cal_cat%TYPE,
9424: cp_v_load igs_ca_type.s_cal_cat%TYPE ) IS
9425: SELECT rl.sub_cal_type,
9426: rl.sub_ci_sequence_number
9427: FROM igs_ca_inst_rel rl,
9428: igs_ca_type ct1,

Line 9428: igs_ca_type ct1,

9424: cp_v_load igs_ca_type.s_cal_cat%TYPE ) IS
9425: SELECT rl.sub_cal_type,
9426: rl.sub_ci_sequence_number
9427: FROM igs_ca_inst_rel rl,
9428: igs_ca_type ct1,
9429: igs_ca_type ct2
9430: WHERE rl.sup_cal_type = ct1.cal_type
9431: AND ct1.s_cal_cat = cp_v_admission
9432: AND rl.sub_cal_type = ct2.cal_type

Line 9429: igs_ca_type ct2

9425: SELECT rl.sub_cal_type,
9426: rl.sub_ci_sequence_number
9427: FROM igs_ca_inst_rel rl,
9428: igs_ca_type ct1,
9429: igs_ca_type ct2
9430: WHERE rl.sup_cal_type = ct1.cal_type
9431: AND ct1.s_cal_cat = cp_v_admission
9432: AND rl.sub_cal_type = ct2.cal_type
9433: AND ct2.s_cal_cat = cp_v_load