APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_LOAN_LINES

Line 1154: from lns_loan_lines

1150: dist.account_name = 'LOAN_RECEIVABLE' and
1151: dist.line_type = 'PRIN' and
1152: nvl(dist.loan_line_id, -1) =
1153: nvl((select max(loan_line_id)
1154: from lns_loan_lines
1155: where status = 'APPROVED'
1156: and LOAN_ID = P_LOAN_ID
1157: and original_flag = 'N'
1158: and adjustment_date <= P_DATE), -1)

Line 7595: lns_loan_lines lines

7591: loan.LOAN_START_DATE
7592: from LNS_LOAN_HEADERS_VL loan,
7593: RA_CUSTOMER_TRX trx,
7594: ar_payment_schedules psa,
7595: lns_loan_lines lines
7596: where loan.loan_id = P_LOAN_ID and
7597: loan.loan_id = lines.loan_id and
7598: lines.reference_type = 'RECEIVABLE' and
7599: lines.REFERENCE_ID = trx.CUSTOMER_TRX_ID and

Line 7771: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_LINES...');

7767: X_ADJ_ID => l_adj_id,
7768: X_ADJ_NUMBER => l_adj_number,
7769: P_ORG_ID => l_org_id);
7770:
7771: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_LINES...');
7772: LNS_LOAN_LINE_PUB.UPDATE_LINE_ADJUSTMENT_NUMBER(
7773: p_init_msg_list => FND_API.G_FALSE
7774: ,p_loan_id => P_LOAN_ID
7775: ,p_loan_line_id => l_line_id

Line 7788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_LINES');

7784: ,x_msg_data => l_msg_data);
7785:
7786: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7787: IF l_return_status = 'S' THEN
7788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_LINES');
7789: ELSE
7790: RAISE FND_API.G_EXC_ERROR;
7791: END IF;
7792: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully created adjustment ' || l_adj_number || ' for original receivable ' || l_trx_number);

Line 10942: lns_loan_lines lines

10938: nvl(lines.installment_number, 1)
10939: from LNS_LOAN_HEADERS_VL loan,
10940: RA_CUSTOMER_TRX trx,
10941: ar_payment_schedules psa,
10942: lns_loan_lines lines
10943: where lines.LOAN_LINE_ID = P_LOAN_LINE_ID and
10944: loan.loan_id = lines.loan_id and
10945: lines.reference_type = 'RECEIVABLE' and
10946: lines.REFERENCE_ID = trx.CUSTOMER_TRX_ID and

Line 11073: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_LINES...');

11069: X_ADJ_ID => l_adj_id,
11070: X_ADJ_NUMBER => l_adj_number,
11071: P_ORG_ID => l_org_id);
11072:
11073: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_LOAN_LINES...');
11074: LNS_LOAN_LINE_PUB.UPDATE_LINE_ADJUSTMENT_NUMBER(
11075: p_init_msg_list => FND_API.G_FALSE
11076: ,p_loan_id => l_loan_id
11077: ,p_loan_line_id => l_line_id

Line 11090: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_LINES');

11086: ,x_msg_data => l_msg_data);
11087:
11088: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
11089: IF l_return_status = 'S' THEN
11090: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_LINES');
11091: ELSE
11092: RAISE FND_API.G_EXC_ERROR;
11093: END IF;
11094: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully created adjustment ' || l_adj_number || ' for additional receivable ' || l_trx_number);