1970: select *
1971: from PSB_WS_POSITION_LINES a
1972: where exists
1973: (select 1
1974: from PSB_WS_LINES_POSITIONS b
1975: where b.position_line_id = a.position_line_id
1976: and b.worksheet_id = p_local_worksheet_id);
1977:
1978: cursor c_wfl (poslineid NUMBER) is
2009: from dual
2010: where exists
2011: (select 1
2012: from PSB_WS_POSITION_LINES a,
2013: PSB_WS_LINES_POSITIONS b
2014: where a.position_line_id = b.position_line_id
2015: and a.position_id = posid
2016: and b.worksheet_id = p_global_worksheet_id);
2017: