DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_FI_F_TYP_CA_INST

Line 7692: igs_fi_f_typ_ca_inst ftci,

7688:
7689: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
7690: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
7691: FROM igs_fi_fee_type ft,
7692: igs_fi_f_typ_ca_inst ftci,
7693: igs_ca_inst ci,
7694: igs_ca_type ct,
7695: igs_ca_stat cs
7696: WHERE ft.s_fee_type = 'SPECIAL'

Line 10350: igs_fi_f_typ_ca_inst ftci,

10346:
10347: CURSOR cur_fee(cp_fee_type IN VARCHAR2) IS
10348: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
10349: FROM igs_fi_fee_type ft,
10350: igs_fi_f_typ_ca_inst ftci,
10351: igs_ca_inst ci,
10352: igs_ca_type ct,
10353: igs_ca_stat cs
10354: WHERE ft.s_fee_type IN ('TUTNFEE', 'OTHER', 'SPECIAL', 'AUDIT')