1775: CURSOR c_get_cust_dtl IS
1776: SELECT cust_acct.party_id,
1777: acct_site.cust_acct_site_id
1778: FROM hz_cust_acct_sites_all acct_site ,
1779: hz_cust_site_uses_all site,
1780: hz_cust_accounts cust_acct
1781: WHERE site.site_use_code = 'BILL_TO'
1782: AND acct_site.status='A'
1783: AND site.status='A'
1791: acct_site.cust_acct_site_id
1792: FROM hz_cust_acct_sites_all acct_site ,
1793: hz_party_sites party_site ,
1794: hz_locations loc ,
1795: hz_cust_site_uses_all site ,
1796: hz_parties party ,
1797: hz_cust_accounts cust_acct
1798: WHERE site.site_use_code = 'BILL_TO'
1799: AND site.cust_acct_site_id = acct_site.cust_acct_site_id