3337: FROM hz_cust_accounts bcust_acct,
3338: hz_cust_acct_sites bacct_site,
3339: hz_cust_site_uses bsite_uses,
3340: hz_party_sites bparty_site,
3341: hz_locations bloc
3342: WHERE bcust_acct.cust_account_id = l_drawee_id
3343: AND bcust_acct.cust_account_id = bacct_site.cust_account_id
3344: AND bacct_site.cust_acct_site_id = bsite_uses.cust_acct_site_id
3345: AND bsite_uses.site_use_code = 'BILL_TO'
3477: FROM hz_cust_accounts bcust_acct,
3478: hz_cust_acct_sites bacct_site,
3479: hz_cust_site_uses bsite_uses,
3480: hz_party_sites bparty_site,
3481: hz_locations bloc
3482: WHERE bcust_acct.cust_account_id = l_drawee_id
3483: AND bcust_acct.cust_account_id = bacct_site.cust_account_id
3484: AND bacct_site.cust_acct_site_id = bsite_uses.cust_acct_site_id
3485: AND bsite_uses.site_use_code = 'BILL_TO'