APPS.POS_SPM_WF_PKG1 dependencies on HZ_PARTY_SITES

Line 374: FROM hz_party_sites hps

370: IS
371: CURSOR l_cur IS
372: SELECT Decode(par.party_site_id, NULL, par.party_site_name,
373: (SELECT hps.party_site_name
374: FROM hz_party_sites hps
375: WHERE hps.party_site_id = par.party_site_id
376: )) address_name
377: FROM pos_address_requests par
378: WHERE par.address_request_id = p_address_request_id;

Line 405: l_address_name hz_party_sites.party_site_name%TYPE;

401: x_receiver OUT nocopy VARCHAR2
402: )
403: IS
404: l_supplier_name ap_suppliers.vendor_name%TYPE;
405: l_address_name hz_party_sites.party_site_name%TYPE;
406: l_itemtype wf_items.item_type%TYPE;
407: l_itemkey wf_items.item_key%TYPE;
408: l_receiver wf_roles.name%TYPE;
409: l_cur g_refcur;