DBA Data[Home] [Help]

APPS.POS_ASN_SEARCH_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 215: from AK_WEB_USER_SEC_ATTR_VALUES ak,

211: select ak.NUMBER_VALUE,
212: vs.VENDOR_SITE_CODE
213: into l_supplier_site_id,
214: l_supplier_site
215: from AK_WEB_USER_SEC_ATTR_VALUES ak,
216: PO_VENDOR_SITES vs
217: where ATTRIBUTE_CODE = 'ICX_SUPPLIER_SITE_ID'
218: and ak.NUMBER_VALUE = vs.VENDOR_SITE_ID
219: and WEB_USER_ID = l_user_id

Line 911: from AK_WEB_USER_SEC_ATTR_VALUES

907: BEGIN
908:
909: select NUMBER_VALUE
910: into l_supplier_id
911: from AK_WEB_USER_SEC_ATTR_VALUES
912: where ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
913: and WEB_USER_ID = p_user_id;
914:
915: /*

Line 941: from AK_WEB_USER_SEC_ATTR_VALUES

937: BEGIN
938:
939: select NUMBER_VALUE
940: into l_supplier_site_id
941: from AK_WEB_USER_SEC_ATTR_VALUES
942: where ATTRIBUTE_CODE = 'ICX_SUPPLIER_SITE_ID'
943: and WEB_USER_ID = p_user_id;
944:
945: return(l_supplier_site_id);