APPS.IGF_SL_DL_PNOTE_ACK dependencies on IGF_SL_LOANS_ALL

Line 94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,

90:
91: PROCEDURE update_resp_edit(p_dlpnr_id igf_sl_dl_pnote_resp_all.dlpnr_id%TYPE,
92: p_status igf_sl_dl_pnote_resp_all.status%TYPE);
93:
94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);
96:
97:
98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

Line 98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

94: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
95: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE);
96:
97:
98: PROCEDURE log_message(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
99: BEGIN
100:
101: IF g_log_start_flag = FALSE THEN
102: fnd_file.put_line(fnd_file.log, '');

Line 500: CURSOR cur_loanid(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

496: GROUP BY fed_fund_code;
497:
498: -- TO get loan_id from the particular loan_number
499:
500: CURSOR cur_loanid(p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
501: SELECT loan_id FROM
502: igf_sl_loans
503: WHERE trim(loan_number)=trim(p_loan_number);
504:

Line 919: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,

915: END LOOP;
916:
917: END update_resp_edit;
918:
919: PROCEDURE compare_disbursements(p_loan_number igf_sl_loans_all.loan_number%TYPE ,
920: loaded_1rec igf_sl_dl_pnote_resp%ROWTYPE)
921: AS
922: /***************************************************************
923: Created By : prchandr