APPS.PON_ATTR_MAPPING dependencies on PON_BID_ATTRIBUTE_VALUES

Line 480: FROM PON_BID_ATTRIBUTE_VALUES

476: , DECODE(l_hdr_enable_weights_flag, 'Y', SUM(WEIGHTED_SCORE), 'N', SUM(SCORE), NULL)
477: INTO l_datatype
478: , l_value
479: , l_score
480: FROM PON_BID_ATTRIBUTE_VALUES
481: WHERE AUCTION_HEADER_ID = p_auction_header_id
482: AND BID_NUMBER = p_bid_number
483: AND AUCTION_LINE_NUMBER = supp_ag_dl_rec.line_number;
484: ELSE

Line 491: FROM PON_BID_ATTRIBUTE_VALUES BID

487: , DECODE(l_hdr_enable_weights_flag, 'Y', SUM(WEIGHTED_SCORE), 'N', SUM(SCORE), NULL)
488: INTO l_datatype
489: , l_value
490: , l_score
491: FROM PON_BID_ATTRIBUTE_VALUES BID
492: , PON_AUCTION_ATTRIBUTES ATTR
493: , PON_AUCTION_SECTIONS SEC
494: WHERE BID.AUCTION_HEADER_ID = p_auction_header_id
495: AND BID.BID_NUMBER = p_bid_number

Line 515: FROM PON_BID_ATTRIBUTE_VALUES

511: , DECODE(l_hdr_enable_weights_flag, 'Y', WEIGHTED_SCORE, 'N', SCORE, NULL)
512: INTO l_datatype
513: , l_value
514: , l_score
515: FROM PON_BID_ATTRIBUTE_VALUES
516: WHERE AUCTION_HEADER_ID = p_auction_header_id
517: AND BID_NUMBER = p_bid_number
518: AND AUCTION_LINE_NUMBER = supp_ag_dl_rec.line_number
519: AND SEQUENCE_NUMBER = supp_mapping_setup_rec.sequence_number;

Line 790: FROM PON_BID_ATTRIBUTE_VALUES

786: , DECODE(l_hdr_enable_weights_flag, 'Y', WEIGHTED_SCORE, 'N', SCORE, NULL)
787: INTO l_datatype
788: , l_value
789: , l_score
790: FROM PON_BID_ATTRIBUTE_VALUES
791: WHERE AUCTION_HEADER_ID = p_auction_header_id
792: AND BID_NUMBER = p_bid_number
793: AND AUCTION_LINE_NUMBER = item_ag_dl_rec.line_number
794: AND SEQUENCE_NUMBER = item_mapping_setup_rec.sequence_number;