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 3935: FROM AK_WEB_USER_SEC_ATTR_VALUES

3931:
3932:
3933: cursor l_vendorId_csr is
3934: SELECT NUMBER_VALUE
3935: FROM AK_WEB_USER_SEC_ATTR_VALUES
3936: WHERE WEB_USER_ID = FND_GLOBAL.USER_ID
3937: AND ATTRIBUTE_CODE = 'ICX_SUPPLIER_ORG_ID'
3938: AND ATTRIBUTE_APPLICATION_ID = 177;
3939:

Line 3965: FROM ak_web_user_sec_attr_values

3961:
3962:
3963: cursor l_vendorSite_csr(p_user_id number) is
3964: SELECT number_value
3965: FROM ak_web_user_sec_attr_values
3966: WHERE web_user_id = p_user_id
3967: AND attribute_code = 'ICX_SUPPLIER_SITE_ID'
3968: AND attribute_application_id = 177;
3969:

Line 3972: FROM ak_web_user_sec_attr_values

3968: AND attribute_application_id = 177;
3969:
3970: cursor l_vendorContact_csr(p_user_id number) is
3971: SELECT number_value
3972: FROM ak_web_user_sec_attr_values
3973: WHERE web_user_id = p_user_id
3974: AND attribute_code = 'ICX_SUPPLIER_CONTACT_ID'
3975: AND attribute_application_id = 177;
3976: