APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_1098T_FTS

Line 641: FROM igs_fi_1098t_fts

637: WHERE tax_year_name = cp_v_tax_year_name;
638:
639: CURSOR cur_val_one_ft(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
640: SELECT 'x'
641: FROM igs_fi_1098t_fts
642: WHERE tax_year_name = cp_v_tax_year_name;
643:
644: BEGIN
645: l_b_validate := TRUE;

Line 936: igs_fi_1098t_fts fts,

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
940: AND crt.credit_class = 'CHGADJ'

Line 1188: igs_fi_1098t_fts fts

1184: cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1185: cp_d_end_date DATE) IS
1186: SELECT inv.*, inv.rowid row_id
1187: FROM igs_fi_inv_int_all inv,
1188: igs_fi_1098t_fts fts
1189: WHERE inv.fee_type = fts.fee_type
1190: AND inv.person_id = cp_n_person_id
1191: AND fts.tax_year_name = cp_v_tax_year_name
1192: AND TRUNC(inv.invoice_creation_date) <= TRUNC(cp_d_end_date)