APPS.PON_SUPPLIER_RESEARCH_PVT dependencies on PON_BID_HEADERS

Line 86: FROM pon_bid_headers pbh,

82: -- Fetch the total invited responses to the negotiations
83: -- i.e. The Supplier was been invited, and has atleast one response.
84: SELECT COUNT( DISTINCT(pbh.auction_header_id)) total_invited
85: INTO l_tot_inv
86: FROM pon_bid_headers pbh,
87: pon_auction_headers pah,
88: pon_bidding_parties pbp
89: WHERE pbh.trading_partner_id = p_tp_id
90: AND pbh. bid_status IN ('ACTIVE')

Line 128: FROM pon_bid_headers pbh,

124: -- Fetch the total un-invited responses to the negotiations
125: -- i.e. The Supplier was not invited, but has atleast one response.
126: SELECT COUNT( DISTINCT(pbh.auction_header_id)) total_uninvited
127: INTO l_tot_uninv
128: FROM pon_bid_headers pbh,
129: pon_auction_headers pah
130: WHERE pbh.trading_partner_id = p_tp_id
131: AND bid_status IN ('ACTIVE')
132: AND pah.auction_header_id = pbh.auction_header_id

Line 171: FROM pon_bid_headers pbh,

167: -- Fetch the total awarded bids
168: -- Count the Negotiations that have atleast one bid got awarded/partially awarded.
169: SELECT COUNT(DISTINCT pbh.auction_header_id) total_awarded
170: INTO l_tot_awd
171: FROM pon_bid_headers pbh,
172: pon_auction_headers pah
173: WHERE pbh.trading_partner_id = p_tp_id
174: AND pah.auction_header_id = pbh.auction_header_id
175: AND pah.auction_status IN ('ACTIVE', 'AUCTION_CLOSED')