APPS.IGF_SL_CL_CHG_PRC dependencies on IGF_SL_LOR_V

Line 57: FROM igf_sl_lor_v isl,

53: ------------------------------------------------------------------
54: CURSOR c_igf_sl_lor_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
55: SELECT isl.anticip_compl_date anticipated_completion_date
56: ,islv.loan_per_end_date loan_end_date
57: FROM igf_sl_lor_v isl,
58: igf_sl_loans_v islv
59: WHERE isl.loan_id = islv.loan_id and
60: isl.loan_id = cp_n_loan_id;
61:

Line 112: l_d_ant_comp_dt igf_sl_lor_v.anticip_compl_date%TYPE;

108: l_v_message_name fnd_new_messages.message_name%TYPE;
109: l_b_return_status BOOLEAN;
110: l_loan_tab igf_aw_packng_subfns.std_loan_tab ;
111: l_n_aid NUMBER ;
112: l_d_ant_comp_dt igf_sl_lor_v.anticip_compl_date%TYPE;
113: l_d_loan_end_dt igf_sl_loans_v.loan_per_end_date%TYPE;
114: BEGIN
115:
116: -- This process would be invoked automatically for each change record created.