APPS.PON_TEAM_SCORING_UTIL_PVT dependencies on PON_AUCTION_SECTIONS

Line 100: ,pon_auction_sections pas

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
102: AND ptmas.auction_header_id = paa.auction_header_id
103: AND paa.line_number = -1
104: AND paa.attribute_list_id = -1

Line 277: ,pon_auction_sections pas

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
281: AND pas.auction_header_id = psts.auction_header_id

Line 378: ,pon_auction_sections pas

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
382: AND paa.attr_group_seq_number = pas.attr_group_seq_number

Line 691: FROM pon_auction_attributes paa, pon_auction_headers_all paha, pon_auction_sections pas

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'