[Home] [Help]
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
100: ,pon_auction_sections pas
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
276: FROM pon_auction_attributes paa
277: ,pon_auction_sections pas
278: ,pon_scoring_team_sections psts
279: WHERE paa.auction_header_id = pas.auction_header_id
280: AND paa.attr_group_seq_number = pas.attr_group_seq_number
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
378: ,pon_auction_sections pas
379: ,pon_scoring_team_sections psts
380: ,pon_scoring_team_members pstm
381: WHERE paa.auction_header_id = pas.auction_header_id
497: AND pbav.auction_line_number = -1
498: AND attribute_name IN
499: (SELECT -- only header attributes that are scored manually
500: paa.attribute_name
501: FROM pon_auction_attributes paa
502: WHERE paa.auction_header_id = pbav.auction_header_id
503: AND paa.line_number = -1
504: AND paa.attribute_list_id = -1
505: AND paa.scoring_method = 'MANUAL')
687: WHERE auction_header_id = p_auction_header_id
688: AND line_number = -1
689: AND sequence_number IN
690: (SELECT paa.sequence_number
691: FROM pon_auction_attributes paa, pon_auction_headers_all paha, pon_auction_sections pas
692: WHERE paa.auction_header_id = p_auction_header_id
693: AND paa.attribute_list_id = -1
694: AND paa.line_number = -1
695: AND paa.scoring_method = 'MANUAL'