DBA Data[Home] [Help]

APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_FI_FEE_STR_STAT

Line 79: igs_fi_fee_str_stat fsst

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
83: AND ftci.fee_type_ci_status = fsst.fee_structure_status

Line 98: igs_fi_fee_str_stat fsst

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
100: AND ft.s_fee_type = g_refund
101: AND ci.cal_type = ftci.fee_cal_type
102: AND ci.sequence_number = ftci.fee_ci_sequence_number