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_POS1 dependencies on PSB_WS_POSITION_LINES

Line 1315: PSB_WS_POSITION_LINES b

1311: cursor c_PosLine is
1312: select b.position_line_id,
1313: b.budget_group_id
1314: from PSB_WS_LINES_POSITIONS a,
1315: PSB_WS_POSITION_LINES b
1316: where a.position_line_id = b.position_line_id
1317: and a.worksheet_id = g_global_worksheet_id
1318: and b.position_id = p_position_id;
1319:

Line 1321: select psb_ws_position_lines_s.nextval PosLineID

1317: and a.worksheet_id = g_global_worksheet_id
1318: and b.position_id = p_position_id;
1319:
1320: cursor c_Seq is
1321: select psb_ws_position_lines_s.nextval PosLineID
1322: from dual;
1323:
1324: BEGIN
1325:

Line 1385: update PSB_WS_POSITION_LINES

1381:
1382: if p_budget_group_id <> l_budget_group_id then
1383: begin
1384:
1385: update PSB_WS_POSITION_LINES
1386: set budget_group_id = p_budget_group_id,
1387: copy_of_position_line_id = decode(p_copy_of_position_line_id, FND_API.G_MISS_NUM, null, p_copy_of_position_line_id),
1388: last_update_date = sysdate,
1389: last_updated_by = l_userid,

Line 1444: insert into PSB_WS_POSITION_LINES

1440: for c_Seq_Rec in c_Seq loop
1441: l_poslineid := c_Seq_Rec.PosLineID;
1442: end loop;
1443:
1444: insert into PSB_WS_POSITION_LINES
1445: (position_line_id,
1446: position_id,
1447: budget_group_id,
1448: copy_of_position_line_id,

Line 3119: FROM psb_ws_position_lines

3115: WHERE set_of_books_id = l_set_of_books_id;
3116:
3117: CURSOR c_positions IS
3118: SELECT position_id
3119: FROM psb_ws_position_lines
3120: WHERE position_line_id = p_position_line_id;
3121:
3122: CURSOR c_fte IS
3123: SELECT annual_fte