APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_FI_FEE_TYPE

Line 56: PROCEDURE get_fee_prd( p_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,

52: END IF;
53: END check_fund_auth;
54:
55:
56: PROCEDURE get_fee_prd( p_fee_type OUT NOCOPY igs_fi_fee_type.fee_type%TYPE,
57: p_fee_cal_type IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
58: p_fee_ci_sequence_number IN OUT NOCOPY igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
59: p_status OUT NOCOPY BOOLEAN) AS
60: /*************************************************************

Line 78: igs_fi_fee_type ft,

74: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE)
75: IS
76: SELECT ft.fee_type
77: FROM igs_fi_f_typ_ca_inst ftci,
78: igs_fi_fee_type ft,
79: igs_fi_fee_str_stat fsst
80: WHERE ft.fee_type = ftci.fee_type
81: AND ftci.fee_cal_type = p_fee_cal_type
82: AND ftci.fee_ci_sequence_number = p_fee_ci_sequence_number

Line 88: l_cur_fee_type igs_fi_fee_type.fee_type%TYPE;

84: AND fsst.s_fee_structure_status = g_active
85: AND ft.s_fee_type = g_refund
86: AND NVL(ft.closed_ind,'N') = 'N';
87:
88: l_cur_fee_type igs_fi_fee_type.fee_type%TYPE;
89:
90: CURSOR cur_ftyp_no_ftci
91: IS
92: SELECT ftci.fee_type,

Line 95: FROM igs_fi_fee_type ft,

91: IS
92: SELECT ftci.fee_type,
93: ci.cal_type,
94: ci.sequence_number
95: FROM igs_fi_fee_type ft,
96: igs_fi_f_typ_ca_inst ftci,
97: igs_ca_inst ci,
98: igs_fi_fee_str_stat fsst
99: WHERE ft.fee_type = ftci.fee_type