APPS.OKE_FIX_MERGE_PUB dependencies on RA_CUSTOMER_MERGES

Line 11: FROM RA_CUSTOMER_MERGES

7: RETURN VARCHAR2 IS
8:
9: CURSOR retrieve_account IS
10: SELECT CUSTOMER_ID,DUPLICATE_ID,PROGRAM_UPDATE_DATE
11: FROM RA_CUSTOMER_MERGES
12: WHERE DUPLICATE_ID=merge_from_acct
13: AND PROGRAM_UPDATE_DATE > record_date
14: AND PROGRAM_UPDATE_DATE > program_date
15: ORDER BY PROGRAM_UPDATE_DATE;

Line 41: FROM RA_CUSTOMER_MERGES

37: RETURN VARCHAR2 IS
38:
39: CURSOR retrieve_account_site_use IS
40: SELECT CUSTOMER_SITE_ID,DUPLICATE_SITE_ID,PROGRAM_UPDATE_DATE
41: FROM RA_CUSTOMER_MERGES
42: WHERE DUPLICATE_SITE_ID=merge_from_site_use
43: AND PROGRAM_UPDATE_DATE > record_date
44: AND PROGRAM_UPDATE_DATE > program_date
45: ORDER BY PROGRAM_UPDATE_DATE;