DBA Data[Home] [Help]

APPS.IGS_FI_CHARGES_API_PVT dependencies on IGS_FI_FEE_STR_STAT

Line 156: igs_fi_fee_str_stat fsst

152: cp_c_status VARCHAR2,
153: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
154: SELECT 'x'
155: FROM igs_fi_f_typ_ca_inst ftci,
156: igs_fi_fee_str_stat fsst
157: WHERE ftci.fee_cal_type = cp_c_fee_cal_type
158: AND ftci.fee_ci_sequence_number = cp_n_fee_ci_sequence_number
159: AND ftci.fee_type = cp_c_fee_type
160: AND ftci.fee_type_ci_status = fsst.fee_structure_status

Line 220: igs_fi_fee_str_stat fsst

216: cp_c_status VARCHAR2,
217: cp_c_transaction_type igs_lookup_values.lookup_code%TYPE) IS
218: SELECT 'x'
219: FROM igs_fi_f_cat_fee_lbl fcfl,
220: igs_fi_fee_str_stat fsst
221: WHERE fcfl.fee_cat = cp_c_fee_cat
222: AND fcfl.fee_type = cp_c_fee_type
223: AND fcfl.fee_liability_status = fsst.fee_structure_status
224: AND (