APPS.LNS_XLA_EVENTS dependencies on LNS_LOAN_HEADERS

Line 111: FROM LNS_LOAN_HEADERS_ALL

107:
108: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
109: SELECT LEGAL_ENTITY_ID
110: ,LOAN_NUMBER
111: FROM LNS_LOAN_HEADERS_ALL
112: WHERE LOAN_ID = X_Loan_Id;
113:
114: CURSOR c_entity_count(c_old_event_id NUMBER) IS
115: SELECT count(event_id)

Line 123: lns_loan_headers lhdr

119: cursor c_sob_id(c_loan_id NUMBER) is
120: select so.ledger_id
121: from lns_system_options sb,
122: gl_ledgers so,
123: lns_loan_headers lhdr
124: where sb.set_of_books_id = so.ledger_id
125: and lhdr.loan_id = c_loan_id
126: and lhdr.org_id = sb.org_id;
127:

Line 416: FROM LNS_LOAN_HEADERS

412: l_sob_id number;
413:
414: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
415: SELECT LEGAL_ENTITY_ID
416: FROM LNS_LOAN_HEADERS
417: WHERE LOAN_ID = X_Loan_Id;
418:
419: cursor c_sob_id(c_loan_id NUMBER) is
420: select so.ledger_id

Line 423: lns_loan_headers lhdr

419: cursor c_sob_id(c_loan_id NUMBER) is
420: select so.ledger_id
421: from lns_system_options sb,
422: gl_ledgers so,
423: lns_loan_headers lhdr
424: where sb.set_of_books_id = so.ledger_id
425: and lhdr.loan_id = c_loan_id
426: and lhdr.org_id = sb.org_id;
427:

Line 565: FROM LNS_LOAN_HEADERS

561: l_msg_data VARCHAR2(32767);
562:
563: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
564: SELECT LEGAL_ENTITY_ID
565: FROM LNS_LOAN_HEADERS
566: WHERE LOAN_ID = X_Loan_Id;
567:
568: cursor c_sob_id(c_loan_id NUMBER) is
569: select so.ledger_id

Line 572: lns_loan_headers lhdr

568: cursor c_sob_id(c_loan_id NUMBER) is
569: select so.ledger_id
570: from lns_system_options sb,
571: gl_ledgers so,
572: lns_loan_headers lhdr
573: where sb.set_of_books_id = so.ledger_id
574: and lhdr.loan_id = c_loan_id
575: and lhdr.org_id = sb.org_id;
576: