APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_CUST_SITE_USES

Line 266: FROM hz_cust_site_uses_all site_uses,

262: END IF;
263: BEGIN
264: SELECT site_uses.site_use_id
265: INTO l_dummy_cust.site_use_id
266: FROM hz_cust_site_uses_all site_uses,
267: hz_cust_acct_sites acct_site
268: WHERE acct_site.cust_account_id = p_customer_id
269: /*AND acct_site.status = 'A' Bug 4317815*/
270: AND acct_site.cust_acct_site_id =

Line 297: -- hz_cust_site_uses

293: --passed in but the site_use_id could not be derived and the case where
294: --location was not passed in
295: IF p_location IS NOT NULL THEN
296: -- for the specified location there is no data in
297: -- hz_cust_site_uses
298: -- the error message was not raised in the defaulting routine.
299: p_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_LOC_INVALID');
301: FND_MSG_PUB.Add;

Line 992: p_location IN hz_cust_site_uses.location%TYPE,

988: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
989: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
990: /* 6612301 */
991: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
992: p_location IN hz_cust_site_uses.location%TYPE,
993: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
994: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
995: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
996: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,