[Home] [Help]
1950: l_return_status VARCHAR2(1);
1951:
1952: cursor c_wal_nps is
1953: select *
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
1961: order by a.code_combination_id, a.current_stage_seq;
1962:
1963: cursor c_wal_ps (poslineid NUMBER) is
1964: select *
1965: from PSB_WS_ACCOUNT_LINES
1966: where position_line_id = poslineid
1967: order by position_line_id, current_stage_seq;
1968:
1969: cursor c_wpl is