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 1109: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting from LNS_CUSTOM_PAYMNT_SCHEDS rows with DUE_DATE < l_NEW_MATURITY_DATE...');

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

Line 1110: delete from LNS_CUSTOM_PAYMNT_SCHEDS

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

Line 1443: from LNS_CUSTOM_PAYMNT_SCHEDS

1439:
1440: -- query count of custom schedule rows with DUE_DATE < l_NEW_MATURITY_DATE
1441: CURSOR custom_sched_count(P_LOAN_ID number, P_MATURITY_DATE date) IS
1442: select count(1)
1443: from LNS_CUSTOM_PAYMNT_SCHEDS
1444: where loan_id = P_LOAN_ID
1445: and DUE_DATE <= P_MATURITY_DATE;
1446:
1447: BEGIN