DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS dependencies on LNS_LOAN_HEADERS

Line 96: FROM LNS_LOAN_HEADERS_ALL

92:
93: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
94: SELECT LEGAL_ENTITY_ID
95: ,LOAN_NUMBER
96: FROM LNS_LOAN_HEADERS_ALL
97: WHERE LOAN_ID = X_Loan_Id;
98:
99: cursor c_sob_id is
100: select so.ledger_id

Line 326: FROM LNS_LOAN_HEADERS

322: l_sob_id number;
323:
324: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
325: SELECT LEGAL_ENTITY_ID
326: FROM LNS_LOAN_HEADERS
327: WHERE LOAN_ID = X_Loan_Id;
328:
329: cursor c_sob_id is
330: select so.set_of_books_id

Line 462: FROM LNS_LOAN_HEADERS

458: l_msg_data VARCHAR2(32767);
459:
460: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
461: SELECT LEGAL_ENTITY_ID
462: FROM LNS_LOAN_HEADERS
463: WHERE LOAN_ID = X_Loan_Id;
464:
465: cursor c_sob_id is
466: select so.set_of_books_id