APPS.PON_AWARD_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 991: x_emd_admin_name pon_neg_team_members.user_name%type;

987: x_bid_number pon_bid_headers.bid_number%type;
988: x_bid_tp_contact_name pon_bid_headers.trading_partner_contact_name%type;
989: x_auction_tp_name pon_auction_headers_all.trading_partner_name%type;
990: x_auction_title pon_auction_headers_all.auction_title%type;
991: x_emd_admin_name pon_neg_team_members.user_name%type;
992: x_doc_number_dsp pon_auction_headers_all.document_number%type;
993: CURSOR all_bidders(p_auction_header_id NUMBER) IS
994: select b.bid_number,
995: b.trading_partner_contact_name contact,

Line 1012: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u

1008: select u.user_name,
1009: a.trading_partner_name auctioneer,
1010: a.auction_title,
1011: a.document_number
1012: from pon_neg_team_members b, pon_auction_headers_all a, fnd_user u
1013: where b.menu_name = 'EMD_ADMIN'
1014: and b.approver_flag = 'Y'
1015: and a.auction_header_id = b.auction_header_id
1016: and u.user_id = b.user_id