DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 670: FROM hz_cust_site_uses_all u,

666: END IF;
667: BEGIN
668: SELECT site_use_id
669: INTO l_payer_context_rec.account_site_id
670: FROM hz_cust_site_uses_all u,
671: hz_cust_acct_sites_all s
672: WHERE s.cust_account_id = p_account_id
673: AND u.cust_acct_site_id = s.cust_acct_site_id
674: AND NVL(u.primary_flag,'N') = 'Y'