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_MERGE_PKG dependencies on RA_CUSTOMER_MERGES

Line 176: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m

172: CURSOR merged_records IS
173: SELECT distinct CUSTOMER_MERGE_HEADER_ID
174: ,LOAN_ID
175: ,CUST_ACCOUNT_ID
176: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m
177: WHERE
178: (yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID)
179: AND m.process_flag = 'N'
180: AND m.request_id = req_id

Line 304: FROM LNS_PARTICIPANTS yt, ra_customer_merges m

300: CURSOR merged_records IS
301: SELECT distinct CUSTOMER_MERGE_HEADER_ID
302: ,PARTICIPANT_ID
303: ,CUST_ACCOUNT_ID
304: FROM LNS_PARTICIPANTS yt, ra_customer_merges m
305: WHERE (
306: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
307: ) AND m.process_flag = 'N'
308: AND m.request_id = req_id