APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 149: HZ_CUST_ACCT_SITES_ALL .CUST_ACCT_SITE_ID%TYPE

145: NUM_COL5_ORIG_LIST INSTALL_LOCATION_ID_LIST_TYPE;
146: NUM_COL5_NEW_LIST INSTALL_LOCATION_ID_LIST_TYPE;
147:
148: TYPE CUST_ACCT_SITE_ID_LIST_TYPE IS TABLE OF
149: HZ_CUST_ACCT_SITES_ALL .CUST_ACCT_SITE_ID%TYPE
150: INDEX BY BINARY_INTEGER;
151:
152: NUM_COL6_ORIG_LIST CUST_ACCT_SITE_ID_LIST_TYPE;
153: NUM_COL6_NEW_LIST CUST_ACCT_SITE_ID_LIST_TYPE;

Line 354: FROM HZ_CUST_ACCT_SITES_ALL

350:
351: /* NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/
352:
353: SELECT PARTY_SITE_ID INTO NUM_COL5_NEW_LIST(I)
354: FROM HZ_CUST_ACCT_SITES_ALL
355: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
356:
357: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
358:

Line 384: INTO NUM_COL6_ORIG_LIST(I) FROM HZ_CUST_ACCT_SITES_ALL

380: FROM HZ_PARTY_SITES
381: WHERE PARTY_ID=l_party_id AND location_id=NUM_COL5_ORIG_LIST(I);
382:
383: SELECT CUST_ACCT_SITE_ID
384: INTO NUM_COL6_ORIG_LIST(I) FROM HZ_CUST_ACCT_SITES_ALL
385: WHERE PARTY_SITE_ID= l_party_site_id
386: AND CUST_ACCOUNT_ID= NUM_COL1_ORIG_LIST(I);
387:
388: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/

Line 392: FROM HZ_CUST_ACCT_SITES_ALL

388: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/
389:
390:
391: SELECT PARTY_SITE_ID INTO l_party_site_id
392: FROM HZ_CUST_ACCT_SITES_ALL
393: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
394:
395: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
396: