DBA Data[Home] [Help]

APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_WS_POSITION_LINES

Line 1971: from PSB_WS_POSITION_LINES a

1967: order by position_line_id, current_stage_seq;
1968:
1969: cursor c_wpl is
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

Line 2012: from PSB_WS_POSITION_LINES a,

2008: select 'Exists'
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);