APPS.OTAP_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 46: FROM OTA_BOOKING_DEALS yt, ra_customer_merges m

42: CURSOR merged_records IS
43: SELECT distinct CUSTOMER_MERGE_HEADER_ID
44: ,BOOKING_DEAL_ID
45: ,yt.CUSTOMER_ID
46: FROM OTA_BOOKING_DEALS yt, ra_customer_merges m
47: WHERE (
48: yt.CUSTOMER_ID = m.DUPLICATE_ID
49: ) AND m.process_flag = 'N'
50: AND m.request_id = req_id

Line 190: FROM OTA_DELEGATE_BOOKINGS yt, ra_customer_merges m

186: ,yt.CUSTOMER_ID
187: ,THIRD_PARTY_CUSTOMER_ID
188: ,CONTACT_ADDRESS_ID
189: ,THIRD_PARTY_ADDRESS_ID
190: FROM OTA_DELEGATE_BOOKINGS yt, ra_customer_merges m
191: WHERE (
192: yt.CUSTOMER_ID = m.DUPLICATE_ID
193: OR yt.THIRD_PARTY_CUSTOMER_ID = m.DUPLICATE_ID
194: OR yt.CONTACT_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID

Line 355: FROM OTA_FINANCE_HEADERS yt, ra_customer_merges m

351: ,FINANCE_HEADER_ID
352: ,yt.CUSTOMER_ID
353: ,yt.ADDRESS_ID
354: ,yt.INVOICE_ADDRESS
355: FROM OTA_FINANCE_HEADERS yt, ra_customer_merges m
356: WHERE (
357: yt.CUSTOMER_ID = m.DUPLICATE_ID
358: ) AND m.process_flag = 'N'
359: AND m.request_id = req_id

Line 535: FROM OTA_EVENT_ASSOCIATIONS yt, ra_customer_merges m

531: SELECT distinct CUSTOMER_MERGE_HEADER_ID
532: ,EVENT_ASSOCIATION_ID
533: ,yt.CUSTOMER_ID
534: ,EVENT_ID
535: FROM OTA_EVENT_ASSOCIATIONS yt, ra_customer_merges m
536: WHERE (
537: yt.CUSTOMER_ID = m.DUPLICATE_ID
538: ) AND m.process_flag = 'N'
539: AND m.request_id = req_id

Line 846: FROM OTA_NOTRNG_HISTORIES yt, ra_customer_merges m

842: CURSOR merged_records IS
843: SELECT distinct CUSTOMER_MERGE_HEADER_ID
844: ,NOTA_HISTORY_ID
845: ,yt.CUSTOMER_ID
846: FROM OTA_NOTRNG_HISTORIES yt, ra_customer_merges m
847: WHERE (
848: yt.CUSTOMER_ID = m.DUPLICATE_ID
849: ) AND m.process_flag = 'N'
850: AND m.request_id = req_id