APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_CREDITS_ALL

Line 205: FROM igs_fi_credits_all crd

201: CURSOR cur_crd(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
202: cp_v_tax_year igs_fi_1098t_setup.tax_year_code%TYPE) IS
203: SELECT crd.rowid row_id,
204: crd.*
205: FROM igs_fi_credits_all crd
206: WHERE party_id = cp_n_person_id
207: AND tax_year_code = cp_v_tax_year
208: FOR UPDATE OF tax_year_code NOWAIT;
209:

Line 783: FUNCTION get_sys_fund_type(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,

779:
780: RETURN l_b_validate;
781: END validate_params;
782:
783: FUNCTION get_sys_fund_type(p_n_credit_id igs_fi_credits_all.credit_id%TYPE,
784: p_n_invoice_id igs_fi_inv_int_all.invoice_id%TYPE) RETURN VARCHAR2 AS
785:
786: /******************************************************************
787: Created By : Amit Gairola

Line 796: CURSOR cur_fund_id_crd(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS

792: Change History
793: Who When What
794: ***************************************************************** */
795:
796: CURSOR cur_fund_id_crd(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
797: SELECT awd.fund_id
798: FROM igf_db_awd_disb_dtl_all disb,
799: igf_aw_award_all awd
800: WHERE awd.award_id = disb.award_id

Line 934: FROM igs_fi_credits_all crd,

930: SELECT crd.*,
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

Line 1425: FROM igs_fi_credits_all crd,

1421: cp_d_end_date DATE) IS
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

Line 1434: CURSOR cur_chk_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS

1430: AND crt.credit_class IN ('SPNSP','EXTFA','INTFA','WAIVER')
1431: AND TRUNC(crd.transaction_date) BETWEEN TRUNC(cp_d_start_date) AND TRUNC(cp_d_end_date)
1432: AND crd.tax_year_code IS NULL;
1433:
1434: CURSOR cur_chk_adj(cp_n_credit_id igs_fi_credits_all.credit_id%TYPE) IS
1435: SELECT 'x'
1436: FROM igf_db_awd_disb_dtl_all
1437: WHERE spnsr_credit_id = cp_n_credit_id;
1438:

Line 1445: FROM igs_fi_credits_all crd,

1441: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1442: cp_d_start_date DATE) IS
1443: SELECT crd.credit_id,
1444: crd.waiver_name
1445: FROM igs_fi_credits_all crd,
1446: igs_fi_1098t_setup stp
1447: WHERE party_id = cp_n_person_id
1448: AND fee_cal_type = cp_v_fee_cal_type
1449: AND fee_ci_sequence_number = cp_n_fee_ci_seq

Line 1683: FROM igs_fi_credits_all crd,

1679: cp_n_fee_ci_seq igs_ca_inst.sequence_number%TYPE,
1680: cp_d_start_date DATE) IS
1681: SELECT crd.credit_id,
1682: crd.waiver_name
1683: FROM igs_fi_credits_all crd,
1684: igs_fi_1098t_setup stp
1685: WHERE crd.party_id = cp_n_person_id
1686: AND crd.fee_cal_type = cp_v_fee_cal_type
1687: AND crd.fee_ci_sequence_number = cp_n_fee_ci_seq