DBA Data[Home] [Help]

APPS.IBE_ORDER_SAVE_PVT dependencies on HZ_PARTIES

Line 946: select party_type from HZ_PARTIES where party_id = cpt_party_id;

942:
943: l_line_rec c_get_lineInfo%rowtype;
944:
945: cursor c_party_type(cpt_party_id NUMBER) is
946: select party_type from HZ_PARTIES where party_id = cpt_party_id;
947:
948: l_party_type VARCHAR2(30);
949: lx_header_siteuse_id NUMBER;
950: l_api_name varchar2(40) := 'DefaultHdrLineAddress';

Line 2719: select party_type from hz_parties where party_id = cr_prtyid;

2715: cursor c_holdid is
2716: select hold_id from oe_hold_definitions where name = 'STORE_HOLD';
2717:
2718: cursor cr_persontype(cr_prtyid number) is
2719: select party_type from hz_parties where party_id = cr_prtyid;
2720:
2721: l_order_header_rec OE_Order_PUB.Header_Rec_Type:= OE_Order_PUB.G_MISS_HEADER_REC;
2722:
2723: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;