APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on PON_MNG_EVAL_TEAM_SECTIONS

Line 37: DELETE FROM pon_mng_eval_team_sections

33:
34: DELETE FROM pon_mng_eval_team_members
35: WHERE auction_header_id = p_auction_header_id;
36:
37: DELETE FROM pon_mng_eval_team_sections
38: WHERE auction_header_id = p_auction_header_id;
39:
40:
41: INSERT INTO pon_mng_eval_team_members

Line 65: INSERT INTO pon_mng_eval_team_sections

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: (
67: auction_header_id,
68: team_id,
69: team_name,

Line 108: pon_mng_eval_team_sections pmets,

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,
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

Line 175: pon_mng_eval_team_sections pmets

171: AND (petm.user_id, pets.section_id) NOT IN
172: (SELECT pmetm.user_id,
173: pmets.section_id
174: FROM pon_mng_eval_team_members pmetm,
175: pon_mng_eval_team_sections pmets
176: WHERE pmetm.auction_header_id = p_auction_header_id
177: AND pmets.auction_header_id = p_auction_header_id
178: AND pmetm.team_id = pmets.team_id
179: )

Line 260: UPDATE pon_mng_eval_team_sections

256:
257:
258: -- 4. Track changes in team sections assignment
259:
260: UPDATE pon_mng_eval_team_sections
261: SET status_code = 'D'
262: WHERE auction_header_id = p_auction_header_id
263: AND (team_id, section_id) NOT IN
264: (SELECT team_id,

Line 270: INSERT INTO pon_mng_eval_team_sections

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
271: (
272: auction_header_id,
273: team_id,
274: team_name,

Line 301: FROM pon_mng_eval_team_sections

297: AND pet.team_id = pets.team_id
298: AND (pets.team_id, pets.section_id) NOT IN
299: (SELECT team_id,
300: section_id
301: FROM pon_mng_eval_team_sections
302: WHERE auction_header_id = p_auction_header_id
303: );
304:
305:

Line 353: pon_mng_eval_team_sections pmets

349: FROM pon_neg_team_members
350: WHERE auction_header_id = p_auction_header_id
351: AND (user_id IN (SELECT pmetm.user_id
352: FROM pon_mng_eval_team_members pmetm,
353: pon_mng_eval_team_sections pmets
354: WHERE pmetm.auction_header_id = p_auction_header_id
355: AND pmets.auction_header_id = p_auction_header_id
356: AND pmets.team_id = pmetm.team_id
357: AND ((pmetm.status_code = 'A' AND

Line 548: pon_mng_eval_team_sections pmets,

544: pmets.team_name,
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

Line 574: pon_mng_eval_team_sections pmets,

570: SELECT pmets.team_name,
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

Line 593: FROM pon_mng_eval_team_sections pmets,

589: IS
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