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.IGF_AW_SS_GEN_PKG dependencies on IGF_AW_FUND_MAST

Line 113: igf_aw_fund_mast mast

109:
110: CURSOR cur_fund_details (cp_award_id NUMBER) IS
111: SELECT mast.*
112: FROM igf_aw_award awd,
113: igf_aw_fund_mast mast
114: WHERE awd.award_id = cp_award_id
115: AND awd.fund_id = mast.fund_id;
116:
117: rec_fund_mast cur_fund_details%ROWTYPE;

Line 669: IGF_AW_FUND_MAST mast

665:
666: CURSOR cur_fund_details ( cp_award_id NUMBER) IS
667: SELECT awd.lock_award_flag lock_awd_flag, mast.*
668: FROM IGF_AW_AWARD awd,
669: IGF_AW_FUND_MAST mast
670: WHERE awd.award_id = cp_award_id
671: AND awd.fund_id = mast.fund_id;
672: fund_mast_rec cur_fund_details%ROWTYPE;
673:

Line 681: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

677: WHERE award_id = cp_award_id;
678:
679: sch_disb_date DATE;
680:
681: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
682: SELECT cat.fed_fund_code
683: FROM igf_aw_fund_mast_all fund,
684: igf_aw_fund_cat_all cat
685: WHERE fund.fund_code = cat.fund_code

Line 683: FROM igf_aw_fund_mast_all fund,

679: sch_disb_date DATE;
680:
681: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
682: SELECT cat.fed_fund_code
683: FROM igf_aw_fund_mast_all fund,
684: igf_aw_fund_cat_all cat
685: WHERE fund.fund_code = cat.fund_code
686: AND fund.fund_id = cp_fund_id;
687:

Line 809: IGF_AW_FUND_MAST mast

805:
806: CURSOR cur_fund_details (cp_award_id NUMBER) IS
807: SELECT awd.lock_award_flag lock_awd_flag, mast.*
808: FROM IGF_AW_AWARD awd,
809: IGF_AW_FUND_MAST mast
810: WHERE awd.award_id = cp_award_id
811: AND awd.fund_id = mast.fund_id;
812: fund_mast_rec cur_fund_details%ROWTYPE;
813:

Line 821: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

817: WHERE award_id = cp_award_id;
818:
819: sch_disb_date DATE;
820:
821: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
822: SELECT cat.fed_fund_code
823: FROM igf_aw_fund_mast_all fund,
824: igf_aw_fund_cat_all cat
825: WHERE fund.fund_code = cat.fund_code

Line 823: FROM igf_aw_fund_mast_all fund,

819: sch_disb_date DATE;
820:
821: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
822: SELECT cat.fed_fund_code
823: FROM igf_aw_fund_mast_all fund,
824: igf_aw_fund_cat_all cat
825: WHERE fund.fund_code = cat.fund_code
826: AND fund.fund_id = cp_fund_id;
827:

Line 949: IGF_AW_FUND_MAST mast

945:
946: CURSOR cur_fund_details (cp_award_id NUMBER) IS
947: SELECT awd.lock_award_flag lock_awd_flag, mast.*
948: FROM IGF_AW_AWARD awd,
949: IGF_AW_FUND_MAST mast
950: WHERE awd.award_id = cp_award_id
951: AND awd.fund_id = mast.fund_id;
952: fund_mast_rec cur_fund_details%ROWTYPE;
953:

Line 961: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

957: WHERE award_id = cp_award_id;
958:
959: sch_disb_date DATE;
960:
961: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
962: SELECT cat.fed_fund_code
963: FROM igf_aw_fund_mast_all fund,
964: igf_aw_fund_cat_all cat
965: WHERE fund.fund_code = cat.fund_code

Line 963: FROM igf_aw_fund_mast_all fund,

959: sch_disb_date DATE;
960:
961: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
962: SELECT cat.fed_fund_code
963: FROM igf_aw_fund_mast_all fund,
964: igf_aw_fund_cat_all cat
965: WHERE fund.fund_code = cat.fund_code
966: AND fund.fund_id = cp_fund_id;
967:

Line 1235: igf_aw_fund_mast_all fmast

1231: cp_award_id igf_aw_award_all.award_id%TYPE
1232: ) IS
1233: SELECT fmast.disb_rounding_code
1234: FROM igf_aw_award_all awd,
1235: igf_aw_fund_mast_all fmast
1236: WHERE awd.fund_id = fmast.fund_id
1237: AND awd.award_id = cp_award_id;
1238: rec_fund_mast c_get_disb_rounding%ROWTYPE;
1239:

Line 1411: IGF_AW_FUND_MAST mast

1407:
1408: CURSOR cur_fund_details ( cp_award_id NUMBER) IS
1409: SELECT awd.lock_award_flag lock_awd_flag, mast.*
1410: FROM IGF_AW_AWARD awd,
1411: IGF_AW_FUND_MAST mast
1412: WHERE awd.award_id = cp_award_id
1413: AND awd.fund_id = mast.fund_id;
1414: fund_mast_rec cur_fund_details%ROWTYPE;
1415:

Line 1423: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1419: WHERE award_id = cp_award_id;
1420:
1421: sch_disb_date DATE;
1422:
1423: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1424: SELECT cat.fed_fund_code
1425: FROM igf_aw_fund_mast_all fund,
1426: igf_aw_fund_cat_all cat
1427: WHERE fund.fund_code = cat.fund_code

Line 1425: FROM igf_aw_fund_mast_all fund,

1421: sch_disb_date DATE;
1422:
1423: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1424: SELECT cat.fed_fund_code
1425: FROM igf_aw_fund_mast_all fund,
1426: igf_aw_fund_cat_all cat
1427: WHERE fund.fund_code = cat.fund_code
1428: AND fund.fund_id = cp_fund_id;
1429:

Line 1589: IGF_AW_FUND_MAST mast

1585:
1586: CURSOR cur_fund_details (cp_award_id NUMBER) IS
1587: SELECT awd.lock_award_flag lock_awd_flag, mast.*
1588: FROM IGF_AW_AWARD awd,
1589: IGF_AW_FUND_MAST mast
1590: WHERE awd.award_id = cp_award_id
1591: AND awd.fund_id = mast.fund_id;
1592: fund_mast_rec cur_fund_details%ROWTYPE;
1593:

Line 1601: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1597: WHERE award_id = cp_award_id;
1598:
1599: sch_disb_date DATE;
1600:
1601: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1602: SELECT cat.fed_fund_code
1603: FROM igf_aw_fund_mast_all fund,
1604: igf_aw_fund_cat_all cat
1605: WHERE fund.fund_code = cat.fund_code

Line 1603: FROM igf_aw_fund_mast_all fund,

1599: sch_disb_date DATE;
1600:
1601: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1602: SELECT cat.fed_fund_code
1603: FROM igf_aw_fund_mast_all fund,
1604: igf_aw_fund_cat_all cat
1605: WHERE fund.fund_code = cat.fund_code
1606: AND fund.fund_id = cp_fund_id;
1607:

Line 1768: IGF_AW_FUND_MAST mast

1764:
1765: CURSOR cur_fund_details (cp_award_id NUMBER) IS
1766: SELECT awd.lock_award_flag lock_awd_flag, mast.*
1767: FROM IGF_AW_AWARD awd,
1768: IGF_AW_FUND_MAST mast
1769: WHERE awd.award_id = cp_award_id
1770: AND awd.fund_id = mast.fund_id;
1771: fund_mast_rec cur_fund_details%ROWTYPE;
1772:

Line 1780: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1776: WHERE award_id = cp_award_id;
1777:
1778: sch_disb_date DATE;
1779:
1780: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1781: SELECT cat.fed_fund_code
1782: FROM igf_aw_fund_mast_all fund,
1783: igf_aw_fund_cat_all cat
1784: WHERE fund.fund_code = cat.fund_code

Line 1782: FROM igf_aw_fund_mast_all fund,

1778: sch_disb_date DATE;
1779:
1780: CURSOR cur_fund_type (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1781: SELECT cat.fed_fund_code
1782: FROM igf_aw_fund_mast_all fund,
1783: igf_aw_fund_cat_all cat
1784: WHERE fund.fund_code = cat.fund_code
1785: AND fund.fund_id = cp_fund_id;
1786: