APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_AUCTION_SECTIONS

Line 328: pon_auction_sections pas

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
332: AND pas.section_id = pmebs.section_id

Line 549: pon_auction_sections pas

545: pas.section_name,
546: pmetm.status_code
547: FROM pon_mng_eval_team_members pmetm,
548: pon_mng_eval_team_sections pmets,
549: pon_auction_sections pas
550: WHERE pmetm.auction_header_id = p_auction_header_id
551: AND pmets.auction_header_id = p_auction_header_id
552: AND pas.auction_header_id = p_auction_header_id
553: AND pmets.team_id = pmetm.team_id

Line 575: pon_auction_sections pas

571: pas.section_name,
572: pmets.status_code
573: FROM pon_mng_eval_team_members pmetm,
574: pon_mng_eval_team_sections pmets,
575: pon_auction_sections pas
576: WHERE pmetm.auction_header_id = p_auction_header_id
577: AND pmets.auction_header_id = p_auction_header_id
578: AND pas.auction_header_id = p_auction_header_id
579: AND pmets.team_id = pmetm.team_id

Line 594: pon_auction_sections pas

590: SELECT pmets.team_name,
591: pas.section_name,
592: pmets.status_code
593: FROM pon_mng_eval_team_sections pmets,
594: pon_auction_sections pas
595: WHERE pmets.auction_header_id = p_auction_header_id
596: AND pas.auction_header_id = p_auction_header_id
597: AND pas.section_id = pmets.section_id
598: AND pmets.status_code IN ('A', 'D')

Line 645: l_section_name pon_auction_sections.section_name%TYPE;

641: l_team_sections_rec team_sections_rec_type;
642:
643: l_user_id NUMBER;
644: l_team_name pon_evaluation_teams.team_name%TYPE;
645: l_section_name pon_auction_sections.section_name%TYPE;
646: l_status_code VARCHAR2(1);
647:
648: l_itemtype VARCHAR2(8);
649: l_itemkey VARCHAR2(240);

Line 945: FROM pon_auction_sections pas,

941: AND psts.team_id = pstm.team_id
942: AND psts.section_id = pets.section_id
943: AND psts.section_id IN
944: (SELECT pas.section_id
945: FROM pon_auction_sections pas,
946: pon_auction_attributes paa
947: WHERE pas.auction_header_id = pbh.auction_header_id
948: AND paa.auction_header_id = pbh.auction_header_id
949: AND paa.attr_group_seq_number = pas.attr_group_seq_number