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
126: and lhdr.org_id = sb.org_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
426: and lhdr.org_id = sb.org_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
575: and lhdr.org_id = sb.org_id;