DBA Data[Home] [Help]

APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_CA_STAT

Line 7695: igs_ca_stat cs

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'
7697: AND ft.closed_ind = 'N'
7698: AND ft.fee_type = ftci.fee_type
7699: AND ft.fee_type = cp_source_fee_type

Line 10353: igs_ca_stat cs

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')
10355: AND ft.closed_ind = 'N'
10356: AND ft.fee_type = ftci.fee_type
10357: AND ft.fee_type = cp_fee_type