APPS.LNS_PAYOFF_PUB dependencies on LNS_SYSTEM_OPTIONS

Line 204: FROM lns_system_options so,

200: l_sob_currency varchar2(30);
201:
202: cursor c_sob_currency is
203: SELECT sb.currency_code
204: FROM lns_system_options so,
205: gl_sets_of_books sb
206: WHERE sb.set_of_books_id = so.set_of_books_id;
207:
208: begin

Line 946: FROM LNS_SYSTEM_OPTIONS

942: X_RA_TERM_ID => l_term_id);
943:
944: select nvl(DAYS_TOGL_AFTER_DUE_DATE, 0)
945: into l_day_togl_after_dd
946: FROM LNS_SYSTEM_OPTIONS
947: WHERE ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID();
948:
949: -- get gl_date
950: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

Line 1213: FROM LNS_SYSTEM_OPTIONS

1209: */
1210: select
1211: DAYS_TOGL_AFTER_DUE_DATE
1212: into g_day_togl_after_dd
1213: FROM LNS_SYSTEM_OPTIONS
1214: WHERE ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID() ;
1215:
1216: open c_due_date(P_PAYMENT_SCHEDULE_ID);
1217: fetch c_due_date into l_due_date;

Line 1354: FROM lns_system_options so,

1350: where loan_id = p_loan_id;
1351:
1352: cursor c_sob_currency is
1353: SELECT sb.currency_code
1354: FROM lns_system_options so,
1355: gl_sets_of_books sb
1356: WHERE sb.set_of_books_id = so.set_of_books_id;
1357:
1358: BEGIN

Line 1617: FROM LNS_SYSTEM_OPTIONS

1613: X_RA_TERM_ID => l_term_id);
1614:
1615: select nvl(DAYS_TOGL_AFTER_DUE_DATE, 0), SET_OF_BOOKS_ID
1616: into l_day_togl_after_dd, l_sob
1617: FROM LNS_SYSTEM_OPTIONS
1618: WHERE ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID();
1619:
1620: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
1621: p_gl_date => (l_trx_date + l_day_togl_after_dd),

Line 2661: LNS_SYSTEM_OPTIONS sys,

2657: sys.CANCELLATION_REC_TRX_ID,
2658: loan.LOAN_CLASS_CODE,
2659: nvl(loan.DISABLE_BILLING_FLAG, 'N')
2660: from lns_loan_headers loan,
2661: LNS_SYSTEM_OPTIONS sys,
2662: LNS_LOAN_CANCELLATIONS cncl
2663: where cncl.LOAN_CANCELLATION_ID = P_LOAN_CANCELLATION_ID and
2664: cncl.LOAN_ID = loan.LOAN_ID and
2665: loan.org_id = sys.org_id;

Line 3601: FROM LNS_SYSTEM_OPTIONS

3597: -- set trx_type_id
3598: l_LOAN_DTL_REC.trx_type_id := l_REFERENCE_TYPE_ID;
3599: if l_LOAN_DTL_REC.trx_type_id is null then
3600: select TRX_TYPE_ID INTO l_LOAN_DTL_REC.trx_type_id
3601: FROM LNS_SYSTEM_OPTIONS
3602: WHERE ORG_ID = l_ORG_ID;
3603: end if;
3604:
3605: -- primary borrower attributes