DBA Data[Home] [Help]

APPS.POA_DBI_SUTIL_PKG dependencies on PO_COMMODITY_CATEGORIES

Line 1442: from po_commodity_categories cat

1438: if(p_selected_commodity = 'ALL' or p_selected_commodity = '-1') then
1439: return '1';
1440: else
1441: select count(*) into l_exists
1442: from po_commodity_categories cat
1443: where cat.commodity_id = p_selected_commodity
1444: and cat.category_id = p_category_code;
1445: end if;
1446: else

Line 1448: from po_commodity_categories cat,

1444: and cat.category_id = p_category_code;
1445: end if;
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