DBA Data[Home] [Help]

APPS.OE_BULK_TAX_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 470: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;

466: l_ship_location_id NUMBER(15);
467: l_bill_party_id NUMBER(15);
468: l_bill_party_site_id NUMBER(15);
469: l_bill_location_id NUMBER(15);
470: l_ship_to_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type;
471: l_ship_to_address_id NUMBER ;
472: l_ship_to_customer_id NUMBER ;
473: l_ship_to_postal_code VARCHAR2(60);
474: l_ship_to_customer_name VARCHAR2(360);

Line 497: cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is

493: from hr_organization_units
494: where organization_id = p_organization_id;
495:
496:
497: cursor getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type) is
498: SELECT /* MOAC_SQL_CHANGE */ s_ship.site_use_id,
499: s_ship.cust_acct_site_id,
500: acct_site_ship.cust_account_id,
501: loc_ship.postal_code,