[Home] [Help]
1954: from PSB_WS_ACCOUNT_LINES a
1955: where position_line_id is null
1956: and exists
1957: (select 1
1958: from PSB_WS_LINES b
1959: where b.account_line_id = a.account_line_id
1960: and b.worksheet_id = p_local_worksheet_id)
1961: order by a.code_combination_id, a.current_stage_seq;
1962:
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: