eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_HEADERS

Line 69: from lns_loan_headers h,

65: cursor c_budget_req(p_loan_id number) is
66: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'Y')
67: ,nvl(h.funds_reserved_flag, 'N')
68: ,nvl(h.gl_date, sysdate)
69: from lns_loan_headers h,
70: lns_loan_products p
71: where p.loan_product_id = h.product_id
72: and h.loan_id = p_loan_id;
73:

Line 76: from lns_loan_headers

72: and h.loan_id = p_loan_id;
73:
74: cursor c_obj_vers(p_loan_id number) is
75: select object_version_number
76: from lns_loan_headers
77: where loan_id = p_loan_id;
78:
79: cursor c_disbursements(p_loan_id number) is
80: select disb_header_id

Line 409: from lns_loan_headers h,

405: cursor c_budget_req(p_loan_id number) is
406: select nvl(p.BDGT_REQ_FOR_APPR_FLAG, 'Y')
407: ,nvl(h.funds_reserved_flag, 'N')
408: ,nvl(h.gl_date, sysdate)
409: from lns_loan_headers h,
410: lns_loan_products p
411: where p.loan_product_id = h.product_id
412: and h.loan_id = p_loan_id;
413:

Line 434: from lns_loan_headers

430: and disbursement_number = 1;
431:
432: cursor c_obj_vers(p_loan_id number) is
433: select object_version_number
434: from lns_loan_headers
435: where loan_id = p_loan_id;
436:
437: cursor c_budget_event(p_loan_id number, p_disb_header_id number) is
438: select count(1)

Line 844: from lns_loan_headers_all h

840: is
841: select h.loan_class_code
842: ,t.loan_type_id
843: ,h.funded_amount
844: from lns_loan_headers_all h
845: ,lns_loan_types t
846: where h.loan_id = p_loan_id
847: and h.loan_type_id = t.loan_type_id;
848:

Line 854: from lns_loan_headers_all h

850: is
851: select h.loan_class_code
852: ,t.loan_type_id
853: ,d.header_amount
854: from lns_loan_headers_all h
855: ,lns_loan_types t
856: ,lns_disb_headers d
857: where h.loan_id = p_loan_id
858: and h.loan_type_id = t.loan_type_id

Line 1126: from lns_loan_headers_all h

1122:
1123: cursor c_loan_info(p_loan_id number) is
1124: select h.loan_class_code
1125: ,h.loan_type_id
1126: from lns_loan_headers_all h
1127: where h.loan_id = p_loan_id;
1128:
1129: begin
1130: l_api_name := 'create_event';

Line 1258: ,lns_loan_headers_all h

1254: -- this is cursor is for reading configuration for multi-fund swap natural account
1255: cursor c_mfar_nat_acct (p_loan_id number) is
1256: select MFAR_NATURAL_ACCOUNT_REC
1257: from lns_default_distribs_all d
1258: ,lns_loan_headers_all h
1259: where account_name = 'MFAR_FUND_ACCOUNT_CHANGE'
1260: and h.loan_id = p_loan_id
1261: and h.loan_class_code = d.loan_class
1262: and h.loan_type_id = d.loan_type_id

Line 1444: ,lns_loan_headers h

1440: -- gets the swap natural account value for LOAN_RECEIVABLE
1441: cursor c_mfar_nat_acct (p_loan_id number) is
1442: select MFAR_NATURAL_ACCOUNT_REC
1443: from lns_default_distribs d
1444: ,lns_loan_headers h
1445: where account_name = 'MFAR_FUND_ACCOUNT_CHANGE'
1446: and h.loan_id = p_loan_id
1447: and h.loan_class_code = d.loan_class
1448: and h.loan_type_id = d.loan_type_id;

Line 1973: || Source Tables: lns_distributions, lns_loan_headers

1969: || p_distribution_id = pk to LNS_DISTRIBUTIONS
1970: ||
1971: || Return value: amount of distribution based from loan funded amount
1972: ||
1973: || Source Tables: lns_distributions, lns_loan_headers
1974: ||
1975: || Target Tables: NA
1976: ||
1977: || KNOWN ISSUES

Line 2002: ,lns_loan_headers lnh

1998:
1999: cursor c_get_distribution(p_distribution_id number) is
2000: select round(lnh.funded_amount * lnd.distribution_percent / 100, curr.precision)
2001: from lns_distributions lnd
2002: ,lns_loan_headers lnh
2003: ,fnd_currencies curr
2004: where lnh.loan_id = lnd.loan_id
2005: and curr.currency_code = lnh.loan_currency
2006: and lnd.distribution_id = p_distribution_id;

Line 2014: ,lns_loan_headers lnh

2010: ,p_distribution_type varchar
2011: ,p_account_type varchar2) is
2012: select max(distribution_id)
2013: from lns_distributions lnd
2014: ,lns_loan_headers lnh
2015: where lnh.loan_id = lnd.loan_id
2016: and lnd.distribution_type = p_distribution_type
2017: and lnd.account_type = p_account_type
2018: and lnh.loan_id = p_loan_id;

Line 2034: ,lns_loan_headers lnh

2030: and distribution_type = p_distribution_type
2031: and account_type = p_account_type
2032: and loan_id = p_loan_id), curr.precision))
2033: from lns_distributions lnd
2034: ,lns_loan_headers lnh
2035: ,fnd_currencies curr
2036: where lnh.loan_id = lnd.loan_id
2037: and lnh.loan_id = p_loan_id
2038: and curr.currency_code = lnh.loan_currency;

Line 2110: || Source Tables: lns_distributions, lns_loan_headers

2106: || 'N' to get amount in loan currency
2107: ||
2108: || Return value: amount of distribution based from loan funded amount
2109: ||
2110: || Source Tables: lns_distributions, lns_loan_headers
2111: ||
2112: || Target Tables: NA
2113: ||
2114: || KNOWN ISSUES

Line 2147: from lns_loan_headers lnh

2143: select lnh.exchange_rate_type
2144: ,lnh.exchange_rate
2145: ,lnh.exchange_date
2146: ,lnh.loan_currency
2147: from lns_loan_headers lnh
2148: where loan_id = p_loan_id;
2149:
2150: cursor c_get_distribution(p_distribution_id number) is
2151: select round(lnh.funded_amount * lnd.distribution_percent / 100, curr.precision)

Line 2153: ,lns_loan_headers lnh

2149:
2150: cursor c_get_distribution(p_distribution_id number) is
2151: select round(lnh.funded_amount * lnd.distribution_percent / 100, curr.precision)
2152: from lns_distributions lnd
2153: ,lns_loan_headers lnh
2154: ,fnd_currencies curr
2155: where lnh.loan_id = lnd.loan_id
2156: and curr.currency_code = lnh.loan_currency
2157: and lnd.distribution_id = p_distribution_id;

Line 2173: ,lns_loan_headers lnh

2169: and distribution_type = p_distribution_type
2170: and account_type = p_account_type
2171: and loan_id = p_loan_id), curr.precision))
2172: from lns_distributions lnd
2173: ,lns_loan_headers lnh
2174: ,fnd_currencies curr
2175: where lnh.loan_id = lnd.loan_id
2176: and lnh.loan_id = p_loan_id
2177: and curr.currency_code = lnh.loan_currency;

Line 2241: from lns_loan_headers lnh

2237: l_amount number;
2238:
2239: cursor c_currency1(p_distribution_id number) is
2240: select lnh.loan_currency
2241: from lns_loan_headers lnh
2242: ,lns_distributions lnd
2243: where lnh.loan_id = lnd.loan_id
2244: and lnd.distribution_id = p_distribution_id;
2245:

Line 2473: from lns_loan_headers_all

2469: l_api_name varchar2(30);
2470:
2471: cursor c_loan_class(p_loan_id number) is
2472: select loan_class_code
2473: from lns_loan_headers_all
2474: where loan_id = p_loan_id;
2475:
2476: begin
2477:

Line 3055: lns_loan_headers_all

3051: cursor c_subsidy_rate (p_loan_id number) is
3052: SELECT
3053: (subsidy_rate/100)
3054: FROM
3055: lns_loan_headers_all
3056: WHERE
3057: loan_id = p_loan_id;
3058:
3059:

Line 3225: || Source Tables: LNS_DEFAULT_DISTRIBUTIONS, lns_loan_headers_all

3221: || Parameter: p_loan_id => loan to default
3222: ||
3223: || Return value: Standard S = Success E = Error U = Unexpected
3224: ||
3225: || Source Tables: LNS_DEFAULT_DISTRIBUTIONS, lns_loan_headers_all
3226: ||
3227: || Target Tables: LNS_DISTRIBUTIONS
3228: ||
3229: || KNOWN ISSUES

Line 3404: from lns_loan_headers_all h

3400: select h.loan_class_code
3401: ,t.loan_type_id
3402: ,h.funded_amount
3403: ,h.legal_entity_id
3404: from lns_loan_headers_all h
3405: ,lns_loan_types t
3406: where h.loan_id = p_loan_id
3407: and h.loan_type_id = t.loan_type_id;
3408:

Line 3432: from lns_loan_headers

3428:
3429: -- cursor to update loan header
3430: cursor c_obj_vers(p_loan_id number) is
3431: select object_version_number
3432: from lns_loan_headers
3433: where loan_id = p_loan_id;
3434:
3435: -- cursor to get documents and check upgrade status
3436: cursor c_get_loan_documents(p_loan_id number) is

Line 4128: from lns_loan_headers h

4124:
4125: cursor c_loan_info(p_loan_id number) is
4126: select h.legal_entity_id
4127: ,h.loan_class_code
4128: from lns_loan_headers h
4129: where h.loan_id = p_loan_id;
4130:
4131: -- this is only for loans entities
4132: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is

Line 4380: from lns_loan_headers

4376: select loan_class_code
4377: ,gl_date
4378: ,OBJECT_VERSION_NUMBER
4379: ,org_id
4380: from lns_loan_headers
4381: where loan_id = c_loan_id;
4382:
4383: CURSOR do_billing_cur(C_LOAN_ID number) IS
4384: select nvl(count(1),0)