APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 154: HZ_CUST_ACCT_SITES_ALL .CUST_ACCT_SITE_ID%TYPE

150: NUM_COL5_ORIG_LIST INSTALL_LOCATION_ID_LIST_TYPE;
151: NUM_COL5_NEW_LIST INSTALL_LOCATION_ID_LIST_TYPE;
152:
153: TYPE CUST_ACCT_SITE_ID_LIST_TYPE IS TABLE OF
154: HZ_CUST_ACCT_SITES_ALL .CUST_ACCT_SITE_ID%TYPE
155: INDEX BY BINARY_INTEGER;
156:
157: NUM_COL6_ORIG_LIST CUST_ACCT_SITE_ID_LIST_TYPE;
158: NUM_COL6_NEW_LIST CUST_ACCT_SITE_ID_LIST_TYPE;

Line 394: FROM HZ_CUST_ACCT_SITES_ALL

390: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
391: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
392: csi_t_gen_utility_pvt.add('NUM_COL6_NEW_LIST - ' || NUM_COL6_NEW_LIST(I));
393: SELECT PARTY_SITE_ID INTO NUM_COL5_NEW_LIST(I)
394: FROM HZ_CUST_ACCT_SITES_ALL
395: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
396:
397: IF l_location_type_code = 'HZ_PARTY_SITES' THEN
398:

Line 418: FROM HZ_CUST_ACCT_SITES_ALL

414: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
415:
416: csi_t_gen_utility_pvt.add('NUM_COL6_NEW_LIST(I) : ' || NUM_COL6_NEW_LIST(I));
417: SELECT PARTY_SITE_ID INTO l_party_site_id
418: FROM HZ_CUST_ACCT_SITES_ALL
419: WHERE CUST_ACCT_SITE_ID= NUM_COL6_NEW_LIST(I);
420:
421: csi_t_gen_utility_pvt.add('Party Site Id : ' || l_party_site_id);
422: csi_t_gen_utility_pvt.add('Location Type Code : ' || l_location_type_code);