eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGF_AW_FUND_CAT_ALL

Line 62: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS

58: FROM igs_fi_1098t_setup
59: WHERE tax_year_name = cp_v_tax_year_name;
60:
61: CURSOR cur_chk_1098t_sfts(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
62: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS
63: SELECT 'x'
64: FROM igs_fi_1098t_sfts
65: WHERE tax_year_name = cp_v_tax_year_name
66: AND sys_fund_type = cp_v_sys_fund_type;

Line 813: igf_aw_fund_cat_all fcat

809:
810: CURSOR cur_sys_fund_type(cp_n_fund_id igf_aw_award_all.fund_id%TYPE) IS
811: SELECT fcat.sys_fund_type
812: FROM igf_aw_fund_mast_all fmast,
813: igf_aw_fund_cat_all fcat
814: WHERE fmast.fund_id = cp_n_fund_id
815: AND fmast.fund_code = fcat.fund_code;
816:
817: l_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

Line 817: l_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

813: igf_aw_fund_cat_all fcat
814: WHERE fmast.fund_id = cp_n_fund_id
815: AND fmast.fund_code = fcat.fund_code;
816:
817: l_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
818: l_n_fund_id igf_aw_award_all.fund_id%TYPE;
819:
820: BEGIN
821:

Line 1404: l_v_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

1400: l_b_process_credit BOOLEAN;
1401: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1402: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
1403:
1404: l_v_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1405: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1406: l_v_message_name VARCHAR2(2000);
1407: l_var VARCHAR2(1);
1408: l_n_box_num NUMBER(5);

Line 1405: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

1401: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
1402: l_n_load_ci_seq igs_ca_inst.sequence_number%TYPE;
1403:
1404: l_v_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1405: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1406: l_v_message_name VARCHAR2(2000);
1407: l_var VARCHAR2(1);
1408: l_n_box_num NUMBER(5);
1409:

Line 1411: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS

1407: l_var VARCHAR2(1);
1408: l_n_box_num NUMBER(5);
1409:
1410: CURSOR cur_chk_spn(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1411: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS
1412: SELECT 'x'
1413: FROM igf_aw_fund_mast_all fmast,
1414: igf_aw_fund_cat_all fcat
1415: WHERE fmast.fund_code = fcat.fund_code

Line 1414: igf_aw_fund_cat_all fcat

1410: CURSOR cur_chk_spn(cp_n_person_id igs_pe_person_base_v.person_id%TYPE,
1411: cp_v_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE) IS
1412: SELECT 'x'
1413: FROM igf_aw_fund_mast_all fmast,
1414: igf_aw_fund_cat_all fcat
1415: WHERE fmast.fund_code = fcat.fund_code
1416: AND fcat.sys_fund_type = cp_v_sys_fund_type
1417: AND fmast.party_id = cp_n_person_id;
1418:

Line 1695: l_v_chg_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

1691: AND TRUNC(stp.end_date) < TRUNC(cp_d_start_date);
1692:
1693: l_rec_orig_crd cur_chk_orig_credit%ROWTYPE;
1694: l_b_process_charge BOOLEAN;
1695: l_v_chg_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1696: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1697: l_b_orig_credit BOOLEAN;
1698: l_n_box_num NUMBER;
1699: l_var VARCHAR2(1);

Line 1696: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;

1692:
1693: l_rec_orig_crd cur_chk_orig_credit%ROWTYPE;
1694: l_b_process_charge BOOLEAN;
1695: l_v_chg_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1696: l_v_orig_crd_sys_fund_type igf_aw_fund_cat_all.sys_fund_type%TYPE;
1697: l_b_orig_credit BOOLEAN;
1698: l_n_box_num NUMBER;
1699: l_var VARCHAR2(1);
1700: BEGIN