APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 390: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all

386:
387: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST - ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));
388:
389: SELECT CUST_ACCT_SITE_ID
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

Line 413: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all

409: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN
410:
411: csi_t_gen_utility_pvt.add('INSTALL_CUSTOMER_SITE_ID_LIST 2- ' || INSTALL_CUSTOMER_SITE_ID_LIST(I));
412: SELECT CUST_ACCT_SITE_ID
413: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_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