211: l_dummy VARCHAR2(10);
212: -- eBTax Changes
213: l_ship_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
214: l_ship_to_party_id hz_cust_accounts.party_id%type;
215: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
216: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
217: l_bill_to_party_id hz_cust_accounts.party_id%type;
218: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
219: l_org_id NUMBER;
214: l_ship_to_party_id hz_cust_accounts.party_id%type;
215: l_ship_to_party_site_id hz_party_sites.party_site_id%type;
216: l_bill_to_cust_Acct_id hz_cust_Accounts.cust_Account_id%type;
217: l_bill_to_party_id hz_cust_accounts.party_id%type;
218: l_bill_to_party_site_id hz_party_sites.party_site_id%type;
219: l_org_id NUMBER;
220: l_legal_entity_id NUMBER;
221:
222: cursor partyinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is