APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_WS_ACCOUNT_LINES

Line 2353: FROM psb_ws_account_lines ws_lines

2349: PSB_POSITION_PAY_DISTRIBUTIONS pos_distr
2350: WHERE EXISTS
2351: (
2352: SELECT 1
2353: FROM psb_ws_account_lines ws_lines
2354: WHERE pos_distr.code_combination_id = ws_lines.code_combination_id
2355: AND ws_lines.salary_account_line = 'Y'
2356: AND ws_lines.ytd_amount <> 0
2357: AND ws_lines.budget_year_id BETWEEN p_from_budget_year_id

Line 4155: from PSB_WS_ACCOUNT_LINES

4151: /*For Bug No : 1808322 End*/
4152:
4153: cursor c_wal_ps(poslineid NUMBER, budgetyearid NUMBER) is
4154: select code_combination_id, currency_code, sum(nvl(ytd_amount, 0)) annual_amount
4155: from PSB_WS_ACCOUNT_LINES
4156: where position_line_id = poslineid
4157: and budget_year_id = budgetyearid
4158: and end_stage_seq is null
4159: group by code_combination_id, currency_code;

Line 4176: from psb_ws_account_lines

4172: sum(nvl(period9_amount,0)) period9_amount,
4173: sum(nvl(period10_amount,0)) period10_amount,
4174: sum(nvl(period11_amount,0)) period11_amount,
4175: sum(nvl(period12_amount,0)) period12_amount
4176: from psb_ws_account_lines
4177: where position_line_id = poslineid
4178: and budget_year_id = budgetyearid
4179: and end_stage_seq is null
4180: group by currency_code, element_set_id;

Line 5456: from psb_ws_position_lines wpl, psb_ws_lines_positions wlp, psb_ws_account_lines wal

5452: select 'Exists'
5453: from dual
5454: where exists
5455: (select 'Exists'
5456: from psb_ws_position_lines wpl, psb_ws_lines_positions wlp, psb_ws_account_lines wal
5457: where wpl.position_id = p_position_id
5458: and wlp.position_line_id = wpl.position_line_id
5459: and wlp.worksheet_id = p_source_id
5460: and wal.position_line_id = wpl.position_line_id);