APPS.POA_DBI_SUTIL_PKG dependencies on FND_USER

Line 702: l_in_join_rec.table_name := 'fnd_user';

698: l_in_join_rec.table_alias := 'sec';
699: p_in_join_tbl.extend;
700: p_in_join_tbl(p_in_join_tbl.count) := l_in_join_rec;
701:
702: l_in_join_rec.table_name := 'fnd_user';
703: l_in_join_rec.table_alias := 'u';
704: p_in_join_tbl.extend;
705: p_in_join_tbl(p_in_join_tbl.count) := l_in_join_rec;
706:

Line 1450: fnd_user usr

1446: else
1447: select count(*) into l_exists
1448: from po_commodity_categories cat,
1449: po_commodity_grants gr,
1450: fnd_user usr
1451: where usr.user_id = fnd_global.user_id
1452: and gr.person_id = usr.employee_id
1453: and cat.commodity_id = gr.commodity_id
1454: and cat.category_id = p_category_code

Line 1710: fnd_user,

1706: l_exists := 0;
1707: /* select count(*) into l_exists
1708: from
1709: po_commodity_grants sec,
1710: fnd_user,
1711: fnd_menu_entries me,
1712: fnd_form_functions f
1713: where
1714: user_id=fnd_global.user_id

Line 1723: fnd_user usr

1719: and sec.menu_id=me.menu_id; */
1720: select count(*) into l_exists
1721: from po_commodity_grants sec,
1722: fnd_menus menu,
1723: fnd_user usr
1724: where usr.user_id = fnd_global.user_id
1725: and sec.person_id = usr.employee_id
1726: and sec.commodity_id = p_commodity_id
1727: and menu.menu_name = 'PO_COMMODITY_MANAGER'