[Home] [Help]
13241:
13242: -- Teams are assigned to sections. Copy the section assignments from
13243: -- the earlier negotiation
13244:
13245: INSERT INTO pon_evaluation_team_sections
13246: (
13247: team_id,
13248: section_id,
13249: auction_header_id,
13261: SYSDATE,
13262: p_user_id,
13263: fnd_global.login_id
13264: FROM pon_auction_sections new_sections,
13265: pon_evaluation_team_sections old_team_sections,
13266: pon_evaluation_teams new_team
13267: WHERE new_sections.auction_header_id = p_auction_header_id
13268: AND old_team_sections.section_id = new_sections.previous_section_id
13269: AND new_team.orig_team_id = old_team_sections.team_id