DBA Data[Home] [Help]

APPS.IGS_PS_GEN_001 dependencies on IGS_FI_F_TYP_CA_INST

Line 2333: igs_fi_f_typ_ca_inst ftci,

2329:
2330: CURSOR c_fee_type_cal_exists(cp_c_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
2331: SELECT ci.cal_type,ci.sequence_number
2332: FROM igs_fi_fee_type ft,
2333: igs_fi_f_typ_ca_inst ftci,
2334: igs_ca_inst ci,
2335: igs_ca_type ct,
2336: igs_ca_stat cs
2337: WHERE ft.s_fee_type IN ('TUTNFEE', 'OTHER', 'SPECIAL', 'AUDIT')

Line 3981: igs_fi_f_typ_ca_inst ftci,

3977:
3978: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
3979: SELECT ci.cal_type,ci.sequence_number
3980: FROM igs_fi_fee_type ft,
3981: igs_fi_f_typ_ca_inst ftci,
3982: igs_ca_inst ci,
3983: igs_ca_type ct,
3984: igs_ca_stat cs
3985: WHERE ft.s_fee_type = 'SPECIAL'