DBA Data[Home] [Help]

APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_EVALUATION_TEAM_SECTIONS

Line 88: FROM pon_evaluation_team_sections pets,

84: SYSDATE,
85: fnd_global.user_id,
86: SYSDATE,
87: fnd_global.login_id
88: FROM pon_evaluation_team_sections pets,
89: pon_evaluation_teams pet
90: WHERE pets.auction_header_id = p_auction_header_id
91: AND pet.auction_header_id = p_auction_header_id
92: AND pet.team_id = pets.team_id;

Line 118: pon_evaluation_team_sections pets

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
122: )

Line 165: pon_evaluation_team_sections pets,

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
169: AND pets.auction_header_id = p_auction_header_id

Line 266: FROM pon_evaluation_team_sections

262: WHERE auction_header_id = p_auction_header_id
263: AND (team_id, section_id) NOT IN
264: (SELECT team_id,
265: section_id
266: FROM pon_evaluation_team_sections
267: WHERE auction_header_id = p_auction_header_id
268: );
269:
270: INSERT INTO pon_mng_eval_team_sections

Line 293: FROM pon_evaluation_team_sections pets,

289: SYSDATE,
290: fnd_global.user_id,
291: SYSDATE,
292: fnd_global.login_id
293: FROM pon_evaluation_team_sections pets,
294: pon_evaluation_teams pet
295: WHERE pets.auction_header_id = p_auction_header_id
296: AND pet.auction_header_id = p_auction_header_id
297: AND pet.team_id = pets.team_id

Line 927: pon_evaluation_team_sections pets,

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
931: WHERE pbh.bid_number = p_bid_number