APPS.POS_EXCELASN_PVT dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 868: from ak_web_user_sec_attr_values

864: select line_number
865: from pos_exasn_lines plnt
866: where not exists(
867: select 1
868: from ak_web_user_sec_attr_values
869: WHERE web_user_id = x_user_id
870: AND attribute_code = 'ICX_SUPPLIER_SITE_ID'
871: AND attribute_application_id = 177
872: and number_value = plnt.vendor_site_id);

Line 880: from ak_web_user_sec_attr_values

876: select line_number
877: from pos_exasn_lines plnt
878: where not exists(
879: select 1
880: from ak_web_user_sec_attr_values
881: WHERE web_user_id = x_user_id
882: AND attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
883: AND attribute_application_id = 177
884: and number_value = plnt.vendor_contact_id);

Line 3861: FROM AK_WEB_USER_SEC_ATTR_VALUES

3857:
3858:
3859: cursor l_vendorId_csr is
3860: SELECT NUMBER_VALUE
3861: FROM AK_WEB_USER_SEC_ATTR_VALUES
3862: WHERE WEB_USER_ID = FND_GLOBAL.USER_ID
3863: AND ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
3864: AND ATTRIBUTE_APPLICATION_ID = 177;
3865:

Line 3891: FROM ak_web_user_sec_attr_values

3887:
3888:
3889: cursor l_vendorSite_csr(p_user_id number) is
3890: SELECT number_value
3891: FROM ak_web_user_sec_attr_values
3892: WHERE web_user_id = p_user_id
3893: AND attribute_code = 'ICX_SUPPLIER_SITE_ID'
3894: AND attribute_application_id = 177;
3895:

Line 3898: FROM ak_web_user_sec_attr_values

3894: AND attribute_application_id = 177;
3895:
3896: cursor l_vendorContact_csr(p_user_id number) is
3897: SELECT number_value
3898: FROM ak_web_user_sec_attr_values
3899: WHERE web_user_id = p_user_id
3900: AND attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
3901: AND attribute_application_id = 177;
3902: