APPS.AR_BILLS_CREATION_LIB_PVT dependencies on HZ_CUST_ACCT_SITES

Line 106: hz_cust_acct_sites acct_site

102: /* modified for tca uptake */
103: SELECT site_uses.SITE_USE_ID
104: INTO p_drawee_site_use_id
105: FROM hz_cust_site_uses site_uses,
106: hz_cust_acct_sites acct_site
107: WHERE acct_site.cust_account_id = p_drawee_id
108: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
109: AND site_uses.site_use_code = 'DRAWEE'
110: AND site_uses.status = 'A'