eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WS_POS3 dependencies on PSB_SET_RELATIONS

Line 2138: PSB_SET_RELATIONS b,

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
2142: and b.parameter_id = p_parameter_id

Line 4654: PSB_SET_RELATIONS b

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;
4658:

Line 4978: PSB_SET_RELATIONS e

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
4982: and c.position_id = d.position_id

Line 5257: PSB_SET_RELATIONS e

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
5261: and e.constraint_id = p_constraint_id)

Line 5299: PSB_SET_RELATIONS f

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
5303: and d.position_id = e.position_id

Line 5324: PSB_SET_RELATIONS g

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
5328: and e.position_id = f.position_id

Line 5352: PSB_SET_RELATIONS f

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
5356: and d.position_id = e.position_id

Line 5382: PSB_SET_RELATIONS g

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
5386: and e.position_id = f.position_id

Line 5891: PSB_SET_RELATIONS f

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
5895: and d.position_id = e.position_id

Line 5913: PSB_SET_RELATIONS f

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
5917: and d.position_id = e.position_id