APPS.PSB_WS_POS3 dependencies on PSB_WS_LINES_POSITIONS

Line 547: PSB_WS_LINES_POSITIONS wlp

543: and pa.pay_element_id = pf.pay_element_id)
544: and exists
545: (select 1
546: from PSB_WS_POSITION_LINES wpl,
547: PSB_WS_LINES_POSITIONS wlp
548: where wpl.position_line_id = wlp.position_line_id
549: and wlp.worksheet_id = p_worksheet_id
550: and wpl.position_id = pp.position_id);
551:

Line 1453: (select 1 from PSB_WS_LINES_POSITIONS wlp, PSB_WS_POSITION_LINES wpl

1449: cursor c_WS is
1450: select 'Exists'
1451: from dual
1452: where exists
1453: (select 1 from PSB_WS_LINES_POSITIONS wlp, PSB_WS_POSITION_LINES wpl
1454: where wlp.worksheet_id = p_worksheet_id
1455: and wpl.position_line_id = wlp.position_line_id
1456: and wpl.position_id = p_position_id);
1457:

Line 4974: from PSB_WS_LINES_POSITIONS a,

4970: cursor c_Positions is
4971: select d.position_id,
4972: c.name,
4973: a.position_line_id
4974: from PSB_WS_LINES_POSITIONS a,
4975: PSB_WS_POSITION_LINES b,
4976: PSB_POSITIONS c,
4977: PSB_BUDGET_POSITIONS d,
4978: PSB_SET_RELATIONS e

Line 5296: from PSB_WS_LINES_POSITIONS c,

5292: from PSB_WS_ELEMENT_LINES a,
5293: PSB_WORKSHEETS b
5294: where exists
5295: (select 1
5296: from PSB_WS_LINES_POSITIONS c,
5297: PSB_WS_POSITION_LINES d,
5298: PSB_BUDGET_POSITIONS e,
5299: PSB_SET_RELATIONS f
5300: where c.position_line_id = a.position_line_id

Line 5321: from PSB_WS_LINES_POSITIONS d,

5317: PSB_WORKSHEETS b,
5318: PSB_PAY_ELEMENTS c
5319: where exists
5320: (select 1
5321: from PSB_WS_LINES_POSITIONS d,
5322: PSB_WS_POSITION_LINES e,
5323: PSB_BUDGET_POSITIONS f,
5324: PSB_SET_RELATIONS g
5325: where d.position_line_id = a.position_line_id

Line 5349: from PSB_WS_LINES_POSITIONS c,

5345: from PSB_WS_ELEMENT_LINES a,
5346: PSB_WORKSHEETS b
5347: where exists
5348: (select 1
5349: from PSB_WS_LINES_POSITIONS c,
5350: PSB_WS_POSITION_LINES d,
5351: PSB_BUDGET_POSITIONS e,
5352: PSB_SET_RELATIONS f
5353: where c.position_line_id = a.position_line_id

Line 5379: from PSB_WS_LINES_POSITIONS d,

5375: PSB_WORKSHEETS b,
5376: PSB_PAY_ELEMENTS c
5377: where exists
5378: (select 1
5379: from PSB_WS_LINES_POSITIONS d,
5380: PSB_WS_POSITION_LINES e,
5381: PSB_BUDGET_POSITIONS f,
5382: PSB_SET_RELATIONS g
5383: where d.position_line_id = a.position_line_id

Line 5888: from PSB_WS_LINES_POSITIONS c,

5884: from PSB_WS_FTE_LINES a,
5885: PSB_WORKSHEETS b
5886: where exists
5887: (select 1
5888: from PSB_WS_LINES_POSITIONS c,
5889: PSB_WS_POSITION_LINES d,
5890: PSB_BUDGET_POSITIONS e,
5891: PSB_SET_RELATIONS f
5892: where c.position_line_id = a.position_line_id

Line 5910: from PSB_WS_LINES_POSITIONS c,

5906: from PSB_WS_FTE_LINES a,
5907: PSB_WORKSHEETS b
5908: where exists
5909: (select 1
5910: from PSB_WS_LINES_POSITIONS c,
5911: PSB_WS_POSITION_LINES d,
5912: PSB_BUDGET_POSITIONS e,
5913: PSB_SET_RELATIONS f
5914: where c.position_line_id = a.position_line_id