DBA Data[Home] [Help]

APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 348: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all

344: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN
345:
346:
347: SELECT CUST_ACCT_SITE_ID
348: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
349: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
350:
351: /* NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL6_ORIG_LIST(I));*/
352:

Line 372: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all

368:
369: ELSIF l_install_location_type_code = 'HZ_LOCATIONS' THEN
370:
371: SELECT CUST_ACCT_SITE_ID
372: INTO NUM_COL6_NEW_LIST(I) FROM hz_cust_site_uses_all
373: WHERE SITE_USE_ID= INSTALL_CUSTOMER_SITE_ID_LIST(I);
374:
375: /* SELECT PARTY_ID
376: INTO l_party_id FROM HZ_CUST_ACCOUNTS