APPS.IGF_SL_DL_GEN_XML dependencies on IGF_SL_LOR_LOC_ALL

Line 12: -- --> check for valid loans in igf_sl_lor_loc_all for document_id

8: -- --> 1.validate parameters
9: -- --> 2.process_loan()
10: -- --> 1.igf_sl_dl_validation.cod_loan_validations()
11: -- --> 2.insert_lor_loc() for valid loans
12: -- --> check for valid loans in igf_sl_lor_loc_all for document_id
13: -- --> if yes then submit_xml_event()
14: -- --> 1.XML Gatway Standard to create xml
15: -- --> 2.store_xml() - workflow process
16: -- --> 1.check for CLOB length, proper document id,

Line 125: SELECT loc.loan_id FROM igf_sl_lor_loc_all loc

121: IS
122:
123: CURSOR cur_cod_loans (p_document_id_txt VARCHAR2)
124: IS
125: SELECT loc.loan_id FROM igf_sl_lor_loc_all loc
126: WHERE loc.document_id_txt = p_document_id_txt;
127:
128: CURSOR cur_cod_disb (p_document_id_txt VARCHAR2)
129: IS

Line 297: FROM igf_sl_lor_loc_all loc

293: setup_rec cur_setup%ROWTYPE;
294:
295: CURSOR cur_loan_oldinfo (p_loan_id NUMBER) IS
296: SELECT loc.*
297: FROM igf_sl_lor_loc_all loc
298: WHERE loc.loan_id = p_loan_id;
299:
300: loan_oldinfo_rec cur_loan_oldinfo%ROWTYPE;
301:

Line 1341: FROM igf_sl_lor_loc_all

1337:
1338: CURSOR cur_cod_dtls (p_document_id_txt VARCHAR2)
1339: IS
1340: SELECT document_id_txt
1341: FROM igf_sl_lor_loc_all
1342: WHERE document_id_txt = p_document_id_txt;
1343:
1344: cod_dtls_rec cur_cod_dtls%ROWTYPE;
1345: