DBA Data[Home] [Help]

APPS.LNS_XLA_EVENTS dependencies on LNS_SYSTEM_OPTIONS

Line 121: from lns_system_options sb,

117: WHERE entity_id = (select entity_id from xla_events where event_id = c_old_event_id);
118:
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

Line 421: from lns_system_options sb,

417: WHERE LOAN_ID = X_Loan_Id;
418:
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

Line 570: from lns_system_options sb,

566: WHERE LOAN_ID = X_Loan_Id;
567:
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