APPS.POA_DBI_SUTIL_PKG dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 721: /* l_in_join_rec.table_name := 'ak_web_user_sec_attr_values';

717: end if;
718: END IF;
719: ELSIF(p_context_code = 'SUPPLIER') THEN
720: null;
721: /* l_in_join_rec.table_name := 'ak_web_user_sec_attr_values';
722: l_in_join_rec.table_alias := 'isp';
723: p_in_join_tbl.extend;
724: p_in_join_tbl(p_in_join_tbl.count) := l_in_join_rec;
725:

Line 1488: from ak_web_user_sec_attr_values isp,

1484: -- Supplier View of Supplier Management Page
1485: l_exists := 0;
1486: /* Check if user has access to p_supplier_id based on iSP Securing Attributes */
1487: select count(*) into l_exists
1488: from ak_web_user_sec_attr_values isp,
1489: fnd_application appl
1490: where isp.web_user_id = fnd_global.user_id
1491: and isp.attribute_application_id = appl.application_id
1492: and appl.application_short_name = 'POS'

Line 1530: ak_web_user_sec_attr_values isp,

1526: select count(*)
1527: into l_exists
1528: from
1529: poa_supplier_sites_v sup,
1530: ak_web_user_sec_attr_values isp,
1531: fnd_application appl
1532: where isp.attribute_application_id = appl.application_id
1533: and isp.number_value = sup.vendor_id
1534: and isp.web_user_id = fnd_global.user_id

Line 2180: ak_web_user_sec_attr_values isp,

2176: FROM (
2177: SELECT id
2178: FROM
2179: poa_suppliers_v v,
2180: ak_web_user_sec_attr_values isp,
2181: fnd_application appl
2182: WHERE
2183: fnd_global.user_id = isp.web_user_id
2184: AND isp.attribute_application_id = appl.application_id