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_EXT_LOAN_PUB dependencies on LNS_CUSTOM_PAYMNT_SCHEDS

Line 1111: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting from LNS_CUSTOM_PAYMNT_SCHEDS rows with DUE_DATE < l_NEW_MATURITY_DATE...');

1107: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done synching');
1108:
1109: if l_customized = 'Y' then
1110:
1111: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting from LNS_CUSTOM_PAYMNT_SCHEDS rows with DUE_DATE < l_NEW_MATURITY_DATE...');
1112: delete from LNS_CUSTOM_PAYMNT_SCHEDS
1113: where loan_id = l_LOAN_ID
1114: and DUE_DATE > l_NEW_MATURITY_DATE;
1115: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');

Line 1112: delete from LNS_CUSTOM_PAYMNT_SCHEDS

1108:
1109: if l_customized = 'Y' then
1110:
1111: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting from LNS_CUSTOM_PAYMNT_SCHEDS rows with DUE_DATE < l_NEW_MATURITY_DATE...');
1112: delete from LNS_CUSTOM_PAYMNT_SCHEDS
1113: where loan_id = l_LOAN_ID
1114: and DUE_DATE > l_NEW_MATURITY_DATE;
1115: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Done');
1116:

Line 1448: from LNS_CUSTOM_PAYMNT_SCHEDS

1444:
1445: -- query count of custom schedule rows with DUE_DATE < l_NEW_MATURITY_DATE
1446: CURSOR custom_sched_count(P_LOAN_ID number, P_MATURITY_DATE date) IS
1447: select count(1)
1448: from LNS_CUSTOM_PAYMNT_SCHEDS
1449: where loan_id = P_LOAN_ID
1450: and DUE_DATE <= P_MATURITY_DATE;
1451:
1452: BEGIN