DBA Data[Home] [Help]

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_CR_TYPES_ALL

Line 935: igs_fi_cr_types_all crt,

931: crd.rowid row_id,
932: fts.fee_type,
933: inv.invoice_id
934: FROM igs_fi_credits_all crd,
935: igs_fi_cr_types_all crt,
936: igs_fi_1098t_fts fts,
937: igs_fi_inv_int_all inv,
938: igs_fi_applications app
939: WHERE crd.credit_type_id = crt.credit_type_id

Line 1426: igs_fi_cr_types_all crt

1422: SELECT crd.*,
1423: crd.rowid row_id,
1424: crt.credit_class
1425: FROM igs_fi_credits_all crd,
1426: igs_fi_cr_types_all crt
1427: WHERE crd.credit_type_id = crt.credit_type_id
1428: AND crd.status = 'CLEARED'
1429: AND crd.party_id = cp_n_person_id
1430: AND crt.credit_class IN ('SPNSP','EXTFA','INTFA','WAIVER')