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_SL_GEN dependencies on IGF_AW_FUND_MAST_ALL

Line 1626: CURSOR c_igf_fmast_fcat (cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS

1622: SELECT fund_id
1623: FROM igf_aw_award_all
1624: WHERE award_id = cp_n_award_id;
1625:
1626: CURSOR c_igf_fmast_fcat (cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1627: SELECT fcat.fed_fund_code
1628: FROM igf_aw_fund_mast_all fmast
1629: ,igf_aw_fund_cat_all fcat
1630: WHERE fmast.fund_code = fcat.fund_code

Line 1628: FROM igf_aw_fund_mast_all fmast

1624: WHERE award_id = cp_n_award_id;
1625:
1626: CURSOR c_igf_fmast_fcat (cp_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE) IS
1627: SELECT fcat.fed_fund_code
1628: FROM igf_aw_fund_mast_all fmast
1629: ,igf_aw_fund_cat_all fcat
1630: WHERE fmast.fund_code = fcat.fund_code
1631: AND fmast.fund_id = cp_n_fund_id;
1632:

Line 1633: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;

1629: ,igf_aw_fund_cat_all fcat
1630: WHERE fmast.fund_code = fcat.fund_code
1631: AND fmast.fund_id = cp_n_fund_id;
1632:
1633: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
1634: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
1635:
1636: BEGIN
1637:

Line 1668: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,

1664:
1665: END get_fed_fund_code;
1666:
1667: FUNCTION check_prc_chg (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1668: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
1669: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
1670: )
1671: RETURN BOOLEAN AS
1672: ------------------------------------------------------------------

Line 1669: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE

1665: END get_fed_fund_code;
1666:
1667: FUNCTION check_prc_chg (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1668: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
1669: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
1670: )
1671: RETURN BOOLEAN AS
1672: ------------------------------------------------------------------
1673: --Created by : Sanil Madathil, Oracle IDC

Line 1690: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,

1686: --Change History:
1687: --Who When What
1688: ------------------------------------------------------------------
1689: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
1690: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
1691: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1692: ) IS
1693: SELECT loans.loan_number
1694: FROM igf_sl_lor_all lor

Line 1691: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE

1687: --Who When What
1688: ------------------------------------------------------------------
1689: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
1690: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
1691: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1692: ) IS
1693: SELECT loans.loan_number
1694: FROM igf_sl_lor_all lor
1695: ,igf_sl_loans_all loans

Line 1697: ,igf_aw_fund_mast_all fmast

1693: SELECT loans.loan_number
1694: FROM igf_sl_lor_all lor
1695: ,igf_sl_loans_all loans
1696: ,igf_aw_award_all awd
1697: ,igf_aw_fund_mast_all fmast
1698: WHERE lor.relationship_cd = cp_v_relationship_cd
1699: AND loans.loan_id = lor.loan_id
1700: AND (loans.loan_status = 'S' OR loans.loan_chg_status = 'S')
1701: AND awd.award_id = loans.award_id

Line 1735: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,

1731: app_exception.raise_exception;
1732: END check_prc_chg;
1733:
1734: FUNCTION check_prc_chgm (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1735: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
1736: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
1737: )
1738: RETURN BOOLEAN AS
1739: ------------------------------------------------------------------

Line 1736: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE

1732: END check_prc_chg;
1733:
1734: FUNCTION check_prc_chgm (p_v_relationship_cd IN igf_sl_cl_setup_all.relationship_cd%TYPE,
1735: p_v_cal_type IN igf_aw_fund_mast_all.ci_cal_type%TYPE ,
1736: p_n_sequence_number IN igf_aw_fund_mast_all.ci_sequence_number%TYPE
1737: )
1738: RETURN BOOLEAN AS
1739: ------------------------------------------------------------------
1740: --Created by : Sanil Madathil, Oracle IDC

Line 1757: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,

1753: --Change History:
1754: --Who When What
1755: ------------------------------------------------------------------
1756: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
1757: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
1758: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1759: ) IS
1760: SELECT loans.loan_number
1761: FROM igf_sl_lor_all lor

Line 1758: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE

1754: --Who When What
1755: ------------------------------------------------------------------
1756: CURSOR c_loan_num ( cp_v_relationship_cd igf_sl_cl_setup_all.relationship_cd%TYPE,
1757: cp_v_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
1758: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1759: ) IS
1760: SELECT loans.loan_number
1761: FROM igf_sl_lor_all lor
1762: ,igf_sl_loans_all loans

Line 1764: ,igf_aw_fund_mast_all fmast

1760: SELECT loans.loan_number
1761: FROM igf_sl_lor_all lor
1762: ,igf_sl_loans_all loans
1763: ,igf_aw_award_all awd
1764: ,igf_aw_fund_mast_all fmast
1765: WHERE lor.relationship_cd = cp_v_relationship_cd
1766: AND loans.loan_id = lor.loan_id
1767: AND awd.award_id = loans.award_id
1768: AND fmast.fund_id = awd.fund_id