APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_EVALUATION_TEAM_MEMBERS

Line 62: FROM pon_evaluation_team_members

58: SYSDATE,
59: fnd_global.user_id,
60: SYSDATE,
61: fnd_global.login_id
62: FROM pon_evaluation_team_members
63: WHERE auction_header_id = p_auction_header_id;
64:
65: INSERT INTO pon_mng_eval_team_sections
66: (

Line 117: FROM pon_evaluation_team_members petm,

113: AND pmetm.team_id = pmets.team_id
114: AND (pmetm.user_id, pmets.section_id) NOT IN
115: (SELECT petm.user_id,
116: pets.section_id
117: FROM pon_evaluation_team_members petm,
118: pon_evaluation_team_sections pets
119: WHERE petm.auction_header_id = p_auction_header_id
120: AND pets.auction_header_id = p_auction_header_id
121: AND petm.team_id = pets.team_id

Line 164: FROM pon_evaluation_team_members petm,

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,
166: pon_bid_headers pbh,
167: fnd_user fu
168: WHERE petm.auction_header_id = p_auction_header_id

Line 223: FROM pon_evaluation_team_members

219: WHERE auction_header_id = p_auction_header_id
220: AND (team_id, user_id) NOT IN
221: (SELECT team_id,
222: user_id
223: FROM pon_evaluation_team_members
224: WHERE auction_header_id = p_auction_header_id
225: );
226:
227: INSERT INTO pon_mng_eval_team_members

Line 248: FROM pon_evaluation_team_members

244: SYSDATE,
245: fnd_global.user_id,
246: SYSDATE,
247: fnd_global.login_id
248: FROM pon_evaluation_team_members
249: WHERE auction_header_id = p_auction_header_id
250: AND (team_id, user_id) NOT IN
251: (SELECT team_id,
252: user_id

Line 926: pon_evaluation_team_members petm,

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,
929: pon_scoring_team_sections psts,
930: fnd_user fus