APPS.IGF_DB_DISB dependencies on IGF_SL_LOANS

Line 102: FUNCTION get_cl_version(p_loan_number igf_sl_loans.loan_number%TYPE)

98:
99: lv_locking_success VARCHAR2(1);
100:
101:
102: FUNCTION get_cl_version(p_loan_number igf_sl_loans.loan_number%TYPE)
103: RETURN VARCHAR2
104: IS
105: /* Created By : bvisvana
106: Created On : 13-Sept-2005

Line 114: CURSOR cur_get_loan_dtls(cp_loan_number igf_sl_loans.loan_number%TYPE)

110: --------------------------------------------------------------------------------------------------
111: */
112: l_cl_version VARCHAR2(20);
113: l_rel_code VARCHAR2(50);
114: CURSOR cur_get_loan_dtls(cp_loan_number igf_sl_loans.loan_number%TYPE)
115: IS SELECT
116: base_id, ci_cal_type, ci_sequence_number
117: FROM igf_sl_loans_v WHERE loan_number = cp_loan_number;
118:

Line 117: FROM igf_sl_loans_v WHERE loan_number = cp_loan_number;

113: l_rel_code VARCHAR2(50);
114: CURSOR cur_get_loan_dtls(cp_loan_number igf_sl_loans.loan_number%TYPE)
115: IS SELECT
116: base_id, ci_cal_type, ci_sequence_number
117: FROM igf_sl_loans_v WHERE loan_number = cp_loan_number;
118:
119: CURSOR cur_get_rel_code(cp_loan_number igf_sl_loans.loan_number%TYPE)
120: IS SELECT relationship_cd
121: FROM igf_sl_lor_v WHERE loan_number = cp_loan_number;

Line 119: CURSOR cur_get_rel_code(cp_loan_number igf_sl_loans.loan_number%TYPE)

115: IS SELECT
116: base_id, ci_cal_type, ci_sequence_number
117: FROM igf_sl_loans_v WHERE loan_number = cp_loan_number;
118:
119: CURSOR cur_get_rel_code(cp_loan_number igf_sl_loans.loan_number%TYPE)
120: IS SELECT relationship_cd
121: FROM igf_sl_lor_v WHERE loan_number = cp_loan_number;
122:
123: get_loan_dtls_rec cur_get_loan_dtls%ROWTYPE;

Line 2375: igf_sl_loans

2371: IS
2372: SELECT
2373: loan_id, loan_number, loan_status, active
2374: FROM
2375: igf_sl_loans
2376: WHERE
2377: award_id = p_award_id;
2378:
2379: get_loans_rec cur_get_loans%ROWTYPE;

Line 2382: CURSOR cur_pnote_stat (p_loan_id igf_sl_loans_all.loan_id%TYPE)

2378:
2379: get_loans_rec cur_get_loans%ROWTYPE;
2380:
2381:
2382: CURSOR cur_pnote_stat (p_loan_id igf_sl_loans_all.loan_id%TYPE)
2383: IS
2384: SELECT
2385: origination_id,
2386: NVL(pnote_status,'N') pnote_status,