APPS.PON_OA_UTIL_PKG dependencies on PON_NEG_TEAM_MEMBERS

Line 192: l_menu_name pon_neg_team_members.menu_name%TYPE;

188: AND pstm.auction_header_id = p_cur_auction_header_id
189: AND pstm.user_id = FND_GLOBAL.user_id;
190:
191: l_team_id pon_scoring_teams.team_id%TYPE;
192: l_menu_name pon_neg_team_members.menu_name%TYPE;
193:
194: BEGIN
195:
196: -- Teams Scoring

Line 207: FROM pon_neg_team_members

203: IF (p_has_scoring_teams_flag = 'Y') THEN
204: BEGIN
205: -- check if user is a scorer first
206: SELECT menu_name INTO l_menu_name
207: FROM pon_neg_team_members
208: WHERE auction_header_id = p_auction_header_id
209: AND list_id = -1
210: AND user_id = FND_GLOBAL.user_id;
211:

Line 1893: FROM pon_neg_team_members pntm

1889: BEGIN
1890: BEGIN
1891: SELECT COUNT(1)
1892: INTO l_member_cnt
1893: FROM pon_neg_team_members pntm
1894: WHERE pntm.auction_header_id = p_auction_header_id
1895: AND (pntm.user_id <> p_user_id
1896: OR EXISTS(SELECT 1
1897: FROM pon_thread_entries pte