14: SELECT
15: ca2.orig_system_reference dup_osr
16: FROM
17: RA_CUSTOMER_MERGES racm,
18: HZ_CUST_ACCOUNTS ca2
19: WHERE
20: racm.request_id = req_id
21: and racm.set_number = set_num
22: and racm.process_flag = 'N'
48: ELSE
49:
50: /* Logic:
51: 1. Get info from ra_customer_merges.
52: 2. Get orig_system_reference from hz_cust_accounts
53: 3. If OSR is like 'EXCHANGE_CUST', veto. This kind of use of OSR
54: by oex billing will soon change when the oex billing
55: design changes.
56: */