APPS.IGS_FI_F_CAT_FEE_LBL_PKG dependencies on IGS_FI_FEE_TYPE

Line 112: CURSOR c_ft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE ) IS

108: (reverse chronological order - newest change first)
109: ***************************************************************/
110:
111: -- Returns the system fee trigger category of a fee type
112: CURSOR c_ft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE ) IS
113: SELECT s_fee_trigger_cat
114: FROM igs_fi_fee_type
115: WHERE fee_type = cp_fee_type;
116:

Line 114: FROM igs_fi_fee_type

110:
111: -- Returns the system fee trigger category of a fee type
112: CURSOR c_ft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE ) IS
113: SELECT s_fee_trigger_cat
114: FROM igs_fi_fee_type
115: WHERE fee_type = cp_fee_type;
116:
117: -- checks if there are records in the IGS_FI_FEE_AS table
118: -- for the input FTCI and a NULL fee Category.

Line 131: CURSOR c_sft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS

127: AND fee_ci_sequence_number = cp_fee_ci_sequence_number
128: AND fee_cat IS NULL;
129:
130: -- Returns the system fee type of a fee type w.r.t Bug # 2144600
131: CURSOR c_sft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
132: SELECT s_fee_type
133: FROM igs_fi_fee_type
134: WHERE fee_type = cp_fee_type;
135:

Line 133: FROM igs_fi_fee_type

129:
130: -- Returns the system fee type of a fee type w.r.t Bug # 2144600
131: CURSOR c_sft(cp_fee_type IN igs_fi_fee_type.fee_type%TYPE) IS
132: SELECT s_fee_type
133: FROM igs_fi_fee_type
134: WHERE fee_type = cp_fee_type;
135:
136: v_message_name varchar2(30);
137: l_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE;

Line 137: l_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE;

133: FROM igs_fi_fee_type
134: WHERE fee_type = cp_fee_type;
135:
136: v_message_name varchar2(30);
137: l_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE;
138: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE; -- added for Bug # 2144600
139: l_institution CONSTANT VARCHAR2(30) := 'INSTITUTN';
140: BEGIN
141: -- Validate system fee type associated with this fee type is not refund w.r.t. Bug # 2144600

Line 138: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE; -- added for Bug # 2144600

134: WHERE fee_type = cp_fee_type;
135:
136: v_message_name varchar2(30);
137: l_s_fee_trigger_cat igs_fi_fee_type.s_fee_trigger_cat%TYPE;
138: l_s_fee_type igs_fi_fee_type.s_fee_type%TYPE; -- added for Bug # 2144600
139: l_institution CONSTANT VARCHAR2(30) := 'INSTITUTN';
140: BEGIN
141: -- Validate system fee type associated with this fee type is not refund w.r.t. Bug # 2144600
142: IF( p_inserting OR p_updating) THEN