DBA Data[Home] [Help]

APPS.PO_AME_WF_PVT dependencies on PO_VENDOR_SITES_ALL

Line 3166: l_supp_lang po_vendor_sites_all.language%TYPE;

3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;
3168: l_authorization_status po_headers.authorization_status%TYPE;
3169: l_header_id po_headers.po_header_id%TYPE;
3170: l_with_terms VARCHAR2(1);

Line 3261: FROM po_vendor_sites_all pv, po_headers_all ph

3257:
3258: BEGIN
3259: SELECT pv.language
3260: INTO l_supp_lang
3261: FROM po_vendor_sites_all pv, po_headers_all ph
3262: WHERE ph.po_header_id = l_header_id
3263: AND ph.vendor_site_id = pv.vendor_site_id;
3264: EXCEPTION
3265: WHEN NO_DATA_FOUND THEN