DBA Data[Home] [Help]

APPS.CSD_RETURNS_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 671: hz_cust_acct_sites_all s

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'
675: AND ROWNUM < 2;