APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_MNG_EVAL_BID_SECTIONS

Line 104: MERGE INTO pon_mng_eval_bid_sections pmebs

100: BEGIN
101:
102: -- 1. Track sections to be excluded from evaluations
103:
104: MERGE INTO pon_mng_eval_bid_sections pmebs
105: USING (SELECT pbh.bid_number,
106: pmets.section_id
107: FROM pon_mng_eval_team_members pmetm,
108: pon_mng_eval_team_sections pmets,

Line 161: MERGE INTO pon_mng_eval_bid_sections pmebs

157:
158:
159: -- 2. Track new sections for the evaluations
160:
161: MERGE INTO pon_mng_eval_bid_sections pmebs
162: USING (SELECT pbh.bid_number,
163: pets.section_id
164: FROM pon_evaluation_team_members petm,
165: pon_evaluation_team_sections pets,

Line 314: FROM pon_mng_eval_bid_sections

310: WHERE auction_header_id = p_auction_header_id
311: AND (bid_number, section_id) IN
312: (SELECT bid_number,
313: section_id
314: FROM pon_mng_eval_bid_sections
315: WHERE auction_header_id = p_auction_header_id
316: AND status_code = 'D'
317: );
318:

Line 327: FROM pon_mng_eval_bid_sections pmebs,

323: AND auction_line_number = -1
324: AND (bid_number, attr_group_seq_number) IN
325: (SELECT pmebs.bid_number,
326: pas.attr_group_seq_number
327: FROM pon_mng_eval_bid_sections pmebs,
328: pon_auction_sections pas
329: WHERE pmebs.auction_header_id = p_auction_header_id
330: AND pmebs.status_code = 'D'
331: AND pas.auction_header_id = p_auction_header_id