APPS.CSI_ACCT_MERGE_PKG dependencies on HZ_PARTY_SITES

Line 344: IF l_install_location_type_code = 'HZ_PARTY_SITES' THEN

340: FROM CSI_ITEM_INSTANCES WHERE INSTANCE_ID=INSTANCE_ID_LIST(I);
341:
342: IF NUM_COL5_ORIG_LIST(I) IS NOT NULL THEN
343:
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

Line 357: IF l_location_type_code = 'HZ_PARTY_SITES' THEN

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:
359: NUM_COL4_NEW_LIST(I):= NUM_COL5_NEW_LIST(I);
360:
361: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN

Line 364: FROM HZ_PARTY_SITES

360:
361: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
362:
363: SELECT LOCATION_ID INTO NUM_COL4_NEW_LIST(I)
364: FROM HZ_PARTY_SITES
365: WHERE PARTY_SITE_ID = NUM_COL5_NEW_LIST(I);
366:
367: END IF;
368:

Line 380: FROM HZ_PARTY_SITES

376: INTO l_party_id FROM HZ_CUST_ACCOUNTS
377: WHERE CUST_ACCOUNT_ID= NUM_COL1_ORIG_LIST(I);
378:
379: SELECT PARTY_SITE_ID INTO l_party_site_id
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

Line 395: IF l_location_type_code = 'HZ_PARTY_SITES' THEN

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:
397: NUM_COL4_NEW_LIST(I):= l_party_site_id;
398:
399: SELECT LOCATION_ID INTO NUM_COL5_NEW_LIST(I)

Line 400: FROM HZ_PARTY_SITES

396:
397: NUM_COL4_NEW_LIST(I):= l_party_site_id;
398:
399: SELECT LOCATION_ID INTO NUM_COL5_NEW_LIST(I)
400: FROM HZ_PARTY_SITES
401: WHERE PARTY_SITE_ID = l_party_site_id;
402:
403:
404: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN

Line 408: FROM HZ_PARTY_SITES

404: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
405:
406: SELECT LOCATION_ID,LOCATION_ID
407: INTO NUM_COL5_NEW_LIST(I), NUM_COL4_NEW_LIST(I)
408: FROM HZ_PARTY_SITES
409: WHERE PARTY_SITE_ID = l_party_site_id;
410:
411: END IF;
412: