APPS.POA_DBI_SUTIL_PKG dependencies on FND_APPLICATION

Line 726: l_in_join_rec.table_name := 'fnd_application';

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:
726: l_in_join_rec.table_name := 'fnd_application';
727: l_in_join_rec.table_alias := 'appl';
728: p_in_join_tbl.extend;
729: p_in_join_tbl(p_in_join_tbl.count) := l_in_join_rec;
730: */

Line 1489: fnd_application appl

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'
1493: and isp.attribute_code = 'ICX_SUPPLIER_ORG_ID'

Line 1531: fnd_application appl

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
1535: and isp.attribute_code = 'ICX_SUPPLIER_ORG_ID'

Line 2181: fnd_application appl

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
2185: AND appl.application_short_name = 'POS'