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 510: CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)

506: TYPE Entity_info_rec_tbl
507: IS
508: TABLE OF Entity_info INDEX BY binary_integer;
509: Entity_info_tbl Entity_info_rec_tbl;
510: CURSOR getlocinfo(p_site_org_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%type)
511: IS
512: SELECT
513: /* MOAC_SQL_CHANGE */
514: s_ship.site_use_id,