APPS.PSB_WS_POS3 dependencies on PSB_BUDGET_POSITIONS

Line 2137: from PSB_BUDGET_POSITIONS a,

2133:
2134: cursor c_Positions is
2135: select a.position_id,
2136: c.name
2137: from PSB_BUDGET_POSITIONS a,
2138: PSB_SET_RELATIONS b,
2139: PSB_POSITIONS c
2140: where a.data_extract_id = p_data_extract_id
2141: and a.account_position_set_id = b.account_position_set_id

Line 4653: from PSB_BUDGET_POSITIONS a,

4649: order by step_number;
4650:
4651: cursor c_Positions is
4652: select a.position_id
4653: from PSB_BUDGET_POSITIONS a,
4654: PSB_SET_RELATIONS b
4655: where a.data_extract_id = p_data_extract_id
4656: and a.account_position_set_id = b.account_position_set_id
4657: and b.constraint_id = p_constraint_id;

Line 4977: PSB_BUDGET_POSITIONS d,

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
4979: where a.position_line_id = b.position_line_id
4980: and a.worksheet_id = p_worksheet_id
4981: and b.position_id = c.position_id

Line 5256: from PSB_BUDGET_POSITIONS d,

5252: PSB_PAY_ELEMENT_OPTIONS b,
5253: PSB_POSITION_ASSIGNMENTS c
5254: where exists
5255: (select 1
5256: from PSB_BUDGET_POSITIONS d,
5257: PSB_SET_RELATIONS e
5258: where d.data_extract_id = p_data_extract_id
5259: and d.position_id = c.position_id
5260: and d.account_position_set_id = e.account_position_set_id

Line 5298: PSB_BUDGET_POSITIONS e,

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
5301: and c.position_line_id = d.position_line_id
5302: and c.worksheet_id = p_worksheet_id

Line 5323: PSB_BUDGET_POSITIONS f,

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
5326: and d.position_line_id = e.position_line_id
5327: and d.worksheet_id = p_worksheet_id

Line 5351: PSB_BUDGET_POSITIONS e,

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
5354: and c.position_line_id = d.position_line_id
5355: and c.worksheet_id = p_worksheet_id

Line 5381: PSB_BUDGET_POSITIONS f,

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
5384: and d.position_line_id = e.position_line_id
5385: and d.worksheet_id = p_worksheet_id

Line 5890: PSB_BUDGET_POSITIONS e,

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
5893: and c.position_line_id = d.position_line_id
5894: and c.worksheet_id = p_worksheet_id

Line 5912: PSB_BUDGET_POSITIONS e,

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
5915: and c.position_line_id = d.position_line_id
5916: and c.worksheet_id = p_worksheet_id