DBA Data[Home] [Help]

APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_BID_HEADERS

Line 109: pon_bid_headers pbh,

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,
109: pon_bid_headers pbh,
110: fnd_user fu
111: WHERE pmetm.auction_header_id = p_auction_header_id
112: AND pmets.auction_header_id = p_auction_header_id
113: AND pmetm.team_id = pmets.team_id

Line 166: pon_bid_headers pbh,

162: USING (SELECT pbh.bid_number,
163: pets.section_id
164: FROM pon_evaluation_team_members petm,
165: pon_evaluation_team_sections pets,
166: pon_bid_headers pbh,
167: fnd_user fu
168: WHERE petm.auction_header_id = p_auction_header_id
169: AND pets.auction_header_id = p_auction_header_id
170: AND petm.team_id = pets.team_id

Line 909: FROM pon_bid_headers pbh,

905: pah.auction_header_id,
906: pah.auction_title,
907: hz.party_name preparer_tp_name,
908: pad.message_suffix
909: FROM pon_bid_headers pbh,
910: pon_auction_headers_all pah,
911: pon_auc_doctypes pad,
912: hz_parties hz
913: WHERE pbh.bid_number = p_bid_number

Line 924: FROM pon_bid_headers pbh,

920: SELECT DISTINCT
921: fus.user_name scorer_user_name,
922: pon_locale_pkg.get_party_display_name(pbh.evaluator_id)
923: AS evaluator_name
924: FROM pon_bid_headers pbh,
925: fnd_user fue,
926: pon_evaluation_team_members petm,
927: pon_evaluation_team_sections pets,
928: pon_scoring_team_members pstm,