DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on WF_USER_ROLES

Line 4260: from wf_user_roles

4256: l_users WF_DIRECTORY.UserTable;
4257:
4258: CURSOR suppliers IS
4259: select user_name
4260: from wf_user_roles
4261: where role_name = x_prev_doc_role_name;
4262:
4263: BEGIN
4264:

Line 6658: from wf_user_roles wfu, fnd_user fnd

6654:
6655:
6656: CURSOR bidders IS
6657: select wfu.user_name user_name, person_party_id
6658: from wf_user_roles wfu, fnd_user fnd
6659: where role_name = x_wf_role_name
6660: and fnd.user_name (+) = wfu.user_name
6661: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6662: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);