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.

[Home] [Help]

APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_LOAN_AMOUNT_ADJS

Line 327: from lns_loan_amount_adjs ladj

323: order by event_id desc;
324:
325: cursor c_loan_adj(c_loan_id number) is
326: select max(ladj.loan_amount_adj_id)
327: from lns_loan_amount_adjs ladj
328: ,xla_transaction_entities xlee
329: ,xla_events xle
330: where ladj.loan_id = c_loan_id
331: and xlee.entity_id = xle.entity_id

Line 399: ,p_table_name => 'LNS_LOAN_AMOUNT_ADJS');

395: ,x_msg_data => l_msg_data
396: ,x_return_status => l_return_status
397: ,p_col_id => p_loan_amount_adj_id
398: ,p_col_name => 'LOAN_AMOUNT_ADJ_ID'
399: ,p_table_name => 'LNS_LOAN_AMOUNT_ADJS');
400:
401: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
402: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
403: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_AMOUNT_ADJ_ID');

Line 1076: ,LNS_LOAN_AMOUNT_ADJS ladj

1072: ,t.loan_type_id
1073: ,ladj.adjustment_amount
1074: from lns_loan_headers_all h
1075: ,lns_loan_types t
1076: ,LNS_LOAN_AMOUNT_ADJS ladj
1077: where h.loan_id = p_loan_id
1078: and h.loan_type_id = t.loan_type_id
1079: and h.loan_id = ladj.loan_id
1080: and ladj.status = 'PENDING'

Line 3822: FROM LNS_LOAN_AMOUNT_ADJS

3818: loan_id = p_loan_id;
3819:
3820: cursor c_loan_adj(c_loan_id number) is
3821: SELECT LOAN_AMOUNT_ADJ_ID
3822: FROM LNS_LOAN_AMOUNT_ADJS
3823: WHERE loan_id = c_loan_id
3824: AND status = 'PENDING';
3825:
3826: begin

Line 5130: from lns_loan_amount_adjs ladj

5126: or source_id_int_2 = -1)
5127:
5128: and source_id_int_3 IN
5129: (select disb.loan_amount_adj_id
5130: from lns_loan_amount_adjs ladj
5131: ,lns_distributions disb
5132: where disb.loan_id = p_loan_id
5133: and disb.loan_amount_adj_id = ladj.loan_amount_adj_id
5134: and disb.account_name = 'LOAN_RECEIVABLE'

Line 5214: from lns_loan_amount_adjs ladj

5210: )
5211: and (source_id_int_3 IS NULL -- Before introducing MD loanAdjustment, source_id_int_3 values are NULL
5212: OR source_id_int_3 = -1
5213: OR source_id_int_3 in (select disb.loan_amount_adj_id
5214: from lns_loan_amount_adjs ladj
5215: ,lns_distributions disb
5216: where disb.loan_id = p_loan_id
5217: and disb.loan_amount_adj_id = ladj.loan_amount_adj_id
5218: and disb.account_name = 'LOAN_RECEIVABLE'

Line 5748: FROM LNS_LOAN_AMOUNT_ADJS

5744:
5745:
5746: cursor c_loan_adj_det(c_loan_amount_adj_id number) is
5747: SELECT LOAN_ID, STATUS, ADJUSTMENT_AMOUNT
5748: FROM LNS_LOAN_AMOUNT_ADJS
5749: WHERE loan_amount_adj_id = c_loan_amount_adj_id;
5750:
5751:
5752: cursor c_loan_adj(c_loan_id number) is

Line 5754: FROM LNS_LOAN_AMOUNT_ADJS

5750:
5751:
5752: cursor c_loan_adj(c_loan_id number) is
5753: SELECT LOAN_AMOUNT_ADJ_ID, STATUS, ADJUSTMENT_AMOUNT
5754: FROM LNS_LOAN_AMOUNT_ADJS
5755: WHERE loan_id = c_loan_id
5756: AND status = 'PENDING';
5757:
5758: BEGIN

Line 5828: ,p_table_name => 'LNS_LOAN_AMOUNT_ADJS');

5824: ,x_msg_data => l_msg_data
5825: ,x_return_status => l_return_status
5826: ,p_col_id => p_loan_amount_adj_id
5827: ,p_col_name => 'LOAN_AMOUNT_ADJ_ID'
5828: ,p_table_name => 'LNS_LOAN_AMOUNT_ADJS');
5829:
5830: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
5831: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
5832: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_AMOUNT_ADJ_ID');

Line 5979: lns_loan_amount_adjs ladj

5975: ,nvl(ladj.funds_reserved_flag, 'N')
5976: ,ladj.EFFECTIVE_DATE -- fix for bug 16068385
5977: from lns_loan_headers h,
5978: lns_loan_products p,
5979: lns_loan_amount_adjs ladj
5980: where p.loan_product_id = h.product_id
5981: and ladj.loan_id = h.loan_id
5982: and ladj.loan_amount_adj_id = c_loan_amount_adj_id;
5983:

Line 6000: FROM LNS_LOAN_AMOUNT_ADJS

5996:
5997:
5998: cursor c_loan_adj_det(c_loan_amount_adj_id number) is
5999: SELECT LOAN_ID, STATUS, ADJUSTMENT_AMOUNT
6000: FROM LNS_LOAN_AMOUNT_ADJS
6001: WHERE loan_amount_adj_id = c_loan_amount_adj_id;
6002:
6003:
6004: cursor c_loan_adj(c_loan_id number) is

Line 6006: FROM LNS_LOAN_AMOUNT_ADJS

6002:
6003:
6004: cursor c_loan_adj(c_loan_id number) is
6005: SELECT LOAN_AMOUNT_ADJ_ID, STATUS, ADJUSTMENT_AMOUNT
6006: FROM LNS_LOAN_AMOUNT_ADJS
6007: WHERE loan_id = c_loan_id
6008: AND status = 'PENDING';
6009:
6010: cursor c_obj_vers(p_loan_id number) is

Line 6017: from lns_loan_amount_adjs

6013: where loan_id = p_loan_id;
6014:
6015: cursor c_obj_vers_adj(c_loan_amount_adj_id number) is
6016: select object_version_number
6017: from lns_loan_amount_adjs
6018: where loan_amount_adj_id = c_loan_amount_adj_id;
6019:
6020:
6021: cursor c_budget_event(c_loan_adj_id number, c_event_type varchar2) is

Line 6100: ,p_table_name => 'LNS_LOAN_AMOUNT_ADJS');

6096: ,x_msg_data => l_msg_data
6097: ,x_return_status => l_return_status
6098: ,p_col_id => p_loan_amount_adj_id
6099: ,p_col_name => 'LOAN_AMOUNT_ADJ_ID'
6100: ,p_table_name => 'LNS_LOAN_AMOUNT_ADJS');
6101:
6102: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6103: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
6104: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_AMOUNT_ADJ_ID');

Line 10163: from LNS_LOAN_AMOUNT_ADJS ladj

10159:
10160: cursor c_loan_adjustment_info(c_loan_id NUMBER, c_loan_amount_adj_id number)
10161: is
10162: select ladj.adjustment_amount
10163: from LNS_LOAN_AMOUNT_ADJS ladj
10164: where ladj.loan_id = p_loan_id
10165: and ladj.status = 'PENDING'
10166: and ladj.loan_amount_adj_id = c_loan_amount_adj_id;
10167: