APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_FEE_TYPE

Line 955: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,

951: -- reported in a prior year
952: CURSOR cur_chk_inv(cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
953: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
954: cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
955: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
956: cp_d_start_date DATE) IS
957: SELECT 'x'
958: FROM igs_fi_inv_int_all inv,
959: igs_fi_1098t_setup stp

Line 1207: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,

1203: AND sequence_number = cp_n_load_ci_seq
1204: AND next_acad_flag = 'Y';
1205:
1206: CURSOR cur_chk_chg(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1207: cp_v_fee_type igs_fi_fee_type.fee_type%TYPE,
1208: cp_v_fee_cal_type igs_ca_inst.cal_type%TYPE,
1209: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1210: cp_d_start_date DATE) IS
1211: SELECT 'x'

Line 1670: igs_fi_fee_type ft

1666: SELECT inv.rowid row_id,
1667: inv.*,
1668: ft.s_fee_type
1669: FROM igs_fi_inv_int_all inv,
1670: igs_fi_fee_type ft
1671: WHERE inv.person_id = cp_n_person_id
1672: AND ft.fee_type = inv.fee_type
1673: AND inv.tax_year_code IS NULL
1674: AND TRUNC(inv.invoice_creation_date) BETWEEN TRUNC(cp_d_start_date) AND TRUNC(cp_d_end_date)