DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on WF_USER_ROLES

Line 3700: from wf_user_roles

3696: x_progress VARCHAR2(3);
3697:
3698: CURSOR suppliers IS
3699: select user_name
3700: from wf_user_roles
3701: where role_name = x_prev_doc_role_name;
3702:
3703: BEGIN
3704:

Line 6062: from wf_user_roles wfu, fnd_user fnd

6058:
6059:
6060: CURSOR bidders IS
6061: select wfu.user_name user_name, person_party_id
6062: from wf_user_roles wfu, fnd_user fnd
6063: where role_name = x_wf_role_name
6064: and fnd.user_name (+) = wfu.user_name
6065: AND wfu.user_name NOT IN (SELECT wf_user_name FROM pon_bidding_parties
6066: WHERE auction_header_id = x_doc_number AND trading_partner_id IS NULL);