1313: a.name,
1314: a.effective_start_date,
1315: a.effective_end_date
1316: from PSB_POSITIONS a,
1317: PSB_WS_POSITION_LINES b
1318: where a.position_id = b.position_id
1319: and b.position_line_id = p_position_line_id;
1320:
1321: cursor c_Element_Assignments is
1784: a.name,
1785: a.effective_start_date,
1786: a.effective_end_date
1787: from PSB_POSITIONS a,
1788: PSB_WS_POSITION_LINES b
1789: where a.position_id = b.position_id
1790: and b.position_line_id = l_position_line_id)
1791: loop
1792: l_position_start_date := c_Positions_Rec.effective_start_date;