APPS.IGF_SL_GEN dependencies on IGF_SL_LOR_ALL

Line 377: p_grade_level_code igf_sl_lor_all.grade_level_code%TYPE)

373: END base10_to_base36;
374:
375:
376: FUNCTION get_grade_level_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
377: p_grade_level_code igf_sl_lor_all.grade_level_code%TYPE)
378: RETURN VARCHAR2
379: AS
380: /*************************************************************
381: Created By : venagara

Line 396: p_enrollment_code igf_sl_lor_all.enrollment_code%TYPE)

392: END get_grade_level_desc;
393:
394:
395: FUNCTION get_enrollment_desc(p_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE,
396: p_enrollment_code igf_sl_lor_all.enrollment_code%TYPE)
397: RETURN VARCHAR2
398: AS
399: /*************************************************************
400: Created By : venagara

Line 1694: FROM igf_sl_lor_all lor

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
1696: ,igf_aw_award_all awd
1697: ,igf_aw_fund_mast_all fmast
1698: WHERE lor.relationship_cd = cp_v_relationship_cd

Line 1761: FROM igf_sl_lor_all lor

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
1763: ,igf_aw_award_all awd
1764: ,igf_aw_fund_mast_all fmast
1765: WHERE lor.relationship_cd = cp_v_relationship_cd