APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_TEAM_MEMBER_ATTR_SCORES

Line 95: FROM pon_team_member_attr_scores ptmas

91: ,paa.weight
92: ,paa.attr_group_seq_number
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

Line 271: DELETE FROM pon_team_member_attr_scores

267: END IF;
268:
269:
270: -- delete child record
271: DELETE FROM pon_team_member_attr_scores
272: WHERE auction_header_id = p_auction_header_id
273: AND user_id = p_user_id
274: AND attribute_sequence_number IN
275: (SELECT paa.sequence_number

Line 295: FROM pon_team_member_attr_scores ptmas

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'
295: FROM pon_team_member_attr_scores ptmas
296: WHERE ptmas.auction_header_id = ptmbs.auction_header_id
297: AND ptmas.user_id = ptmbs.user_id);
298:
299: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 373: DELETE FROM pon_team_member_attr_scores ptmas

369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
370: END IF;
371:
372: -- delete child record
373: DELETE FROM pon_team_member_attr_scores ptmas
374: WHERE ptmas.auction_header_id = p_auction_header_id
375: AND (user_id, attribute_sequence_number) IN
376: (SELECT pstm.user_id, paa.sequence_number
377: FROM pon_auction_attributes paa

Line 412: FROM pon_team_member_attr_scores ptmas

408: AND NOT EXISTS -- where there is no row for a bid in the child table
409: (
410: SELECT
411: 'x'
412: FROM pon_team_member_attr_scores ptmas
413: WHERE ptmas.auction_header_id = ptmbs.auction_header_id
414: AND ptmas.bid_number = ptmbs.bid_number
415: AND ptmas.user_id = ptmbs.user_id
416: );