APPS.HZ_PAYMENT_METHOD_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 415: FROM HZ_CUST_SITE_USES_ALL casu, HZ_CUST_ACCT_SITES cas

411: where cust_account_id = l_ca_id;
412:
413: CURSOR check_site_use_id(l_ca_id NUMBER, l_casu_id NUMBER) IS
414: SELECT 'X'
415: FROM HZ_CUST_SITE_USES_ALL casu, HZ_CUST_ACCT_SITES cas
416: WHERE casu.cust_acct_site_id = cas.cust_acct_site_id
417: AND cas.cust_account_id = l_ca_id
418: AND casu.site_use_id = l_casu_id;
419:

Line 479: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_SITE_USES_ALL');

475: CLOSE check_site_use_id;
476: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
477: FND_MESSAGE.SET_TOKEN('FK','SITE_USE_ID');
478: FND_MESSAGE.SET_TOKEN('COLUMN','SITE_USE_ID');
479: FND_MESSAGE.SET_TOKEN('TABLE','HZ_CUST_SITE_USES_ALL');
480: FND_MSG_PUB.ADD;
481: RAISE FND_API.G_EXC_ERROR;
482: END IF;
483: CLOSE check_site_use_id;