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 286: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m

282: CURSOR merged_records IS
283: SELECT distinct CUSTOMER_MERGE_HEADER_ID
284: ,LOAN_ID
285: ,CUST_ACCOUNT_ID
286: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m
287: WHERE
288: (yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID)
289: AND m.process_flag = 'N'
290: AND m.request_id = req_id

Line 297: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m

293: CURSOR merged_records2 IS
294: SELECT distinct CUSTOMER_MERGE_HEADER_ID
295: ,LOAN_ID
296: ,CUSTOMER_ADDRESS_ID
297: FROM LNS_LOAN_HEADERS yt, ra_customer_merges m
298: WHERE
299: (yt.BILL_TO_ACCT_SITE_ID = m.DUPLICATE_ADDRESS_ID)
300: AND m.process_flag = 'N'
301: AND m.request_id = req_id

Line 553: FROM LNS_PARTICIPANTS yt, ra_customer_merges m

549: CURSOR merged_records IS
550: SELECT distinct CUSTOMER_MERGE_HEADER_ID
551: ,PARTICIPANT_ID
552: ,CUST_ACCOUNT_ID
553: FROM LNS_PARTICIPANTS yt, ra_customer_merges m
554: WHERE (
555: yt.CUST_ACCOUNT_ID = m.DUPLICATE_ID
556: ) AND m.process_flag = 'N'
557: AND m.request_id = req_id

Line 564: FROM LNS_PARTICIPANTS yt, ra_customer_merges m

560: CURSOR merged_records2 IS
561: SELECT distinct CUSTOMER_MERGE_HEADER_ID
562: ,PARTICIPANT_ID
563: ,CUSTOMER_ADDRESS_ID
564: FROM LNS_PARTICIPANTS yt, ra_customer_merges m
565: WHERE
566: (yt.BILL_TO_ACCT_SITE_ID = m.DUPLICATE_ADDRESS_ID)
567: AND m.process_flag = 'N'
568: AND m.request_id = req_id