APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_CUST_SITE_USES

Line 267: FROM hz_cust_site_uses_all site_uses,

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

Line 298: -- hz_cust_site_uses

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

Line 1001: p_location IN hz_cust_site_uses.location%TYPE,

997: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE,
998: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,
999: /* 6612301 */
1000: p_customer_bank_account_id IN OUT NOCOPY ar_cash_receipts.customer_bank_account_id%TYPE,
1001: p_location IN hz_cust_site_uses.location%TYPE,
1002: p_customer_site_use_id IN OUT NOCOPY ar_cash_receipts.customer_site_use_id%TYPE,
1003: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE,
1004: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE,
1005: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE,