APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_TEAM_MEMBER_BID_SCORES

Line 97: ,pon_team_member_bid_scores ptmbs

93: ,paa.attr_disp_seq_number
94: ,null old_value
95: FROM pon_team_member_attr_scores ptmas
96: ,pon_auction_attributes paa
97: ,pon_team_member_bid_scores ptmbs
98: ,pon_bid_headers pbh
99: ,pon_auction_headers_all paha
100: ,pon_auction_sections pas
101: WHERE ptmas.auction_header_id = p_auction_header_id

Line 289: -- delete that bid and user from the pon_team_member_bid_scores

285:
286: -- if no rows exist in the pon_team_member_attribute_scores
287: -- for this user
288: -- for a bid
289: -- delete that bid and user from the pon_team_member_bid_scores
290: DELETE FROM pon_team_member_bid_scores ptmbs
291: WHERE ptmbs.auction_header_id = p_auction_header_id
292: AND ptmbs.user_id = p_user_id
293: AND NOT EXISTS

Line 290: DELETE FROM pon_team_member_bid_scores ptmbs

286: -- if no rows exist in the pon_team_member_attribute_scores
287: -- for this user
288: -- for a bid
289: -- delete that bid and user from the pon_team_member_bid_scores
290: DELETE FROM pon_team_member_bid_scores ptmbs
291: WHERE ptmbs.auction_header_id = p_auction_header_id
292: AND ptmbs.user_id = p_user_id
293: AND NOT EXISTS
294: (SELECT 'x'

Line 396: -- delete that bid and user from the pon_team_member_bid_scores

392:
393: -- if no rows exist in the pon_team_member_attribute_scores
394: -- for the users of this team and
395: -- for a bid
396: -- delete that bid and user from the pon_team_member_bid_scores
397: DELETE
398: FROM pon_team_member_bid_scores ptmbs
399: WHERE ptmbs.auction_header_id = p_auction_header_id
400: AND ptmbs.user_id IN

Line 398: FROM pon_team_member_bid_scores ptmbs

394: -- for the users of this team and
395: -- for a bid
396: -- delete that bid and user from the pon_team_member_bid_scores
397: DELETE
398: FROM pon_team_member_bid_scores ptmbs
399: WHERE ptmbs.auction_header_id = p_auction_header_id
400: AND ptmbs.user_id IN
401: (
402: SELECT -- for all users of this team