APPS.POS_SPM_WF_PKG1 dependencies on HZ_PARTY_SITES

Line 322: FROM hz_party_sites hps

318: IS
319: CURSOR l_cur IS
320: SELECT Decode(par.party_site_id, NULL, par.party_site_name,
321: (SELECT hps.party_site_name
322: FROM hz_party_sites hps
323: WHERE hps.party_site_id = par.party_site_id
324: )) address_name
325: FROM pos_address_requests par
326: WHERE par.address_request_id = p_address_request_id;

Line 353: l_address_name hz_party_sites.party_site_name%TYPE;

349: x_receiver OUT nocopy VARCHAR2
350: )
351: IS
352: l_supplier_name ap_suppliers.vendor_name%TYPE;
353: l_address_name hz_party_sites.party_site_name%TYPE;
354: l_itemtype wf_items.item_type%TYPE;
355: l_itemkey wf_items.item_key%TYPE;
356: l_receiver wf_roles.name%TYPE;
357: l_cur g_refcur;