APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_POSITION_ACCOUNTS

Line 4680: from PSB_POSITION_ACCOUNTS

4676:
4677: cursor c_distributions is
4678: select position_account_line_id, position_id, code_combination_id,
4679: budget_group_id, amount, start_date, end_date, currency_code
4680: from PSB_POSITION_ACCOUNTS
4681: where budget_revision_id = p_budget_revision_id;
4682:
4683: cursor c_assignments is
4684: select *

Line 6485: FROM psb_position_accounts

6481: l_note VARCHAR2(4000) ; -- Bug#4675858
6482: --
6483: CURSOR c_currdist IS
6484: SELECT code_combination_id, start_date, end_date, amount
6485: FROM psb_position_accounts
6486: WHERE position_id = p_position_id
6487: AND NVL (hr_budget_id, -1) = NVL (p_hr_budget_id, -1)
6488: AND currency_code = g_func_currency
6489: AND base_line_version = 'C'

Line 9849: -- Delete from psb_position_accounts.

9845: DELETE psb_pay_element_rates
9846: WHERE worksheet_id = p_budget_revision_id ;
9847: /* Bug No 2482305 End */
9848:
9849: -- Delete from psb_position_accounts.
9850: DELETE psb_position_accounts
9851: WHERE budget_revision_id = p_budget_revision_id ;
9852:
9853: -- Delete from psb_position_fte.

Line 9850: DELETE psb_position_accounts

9846: WHERE worksheet_id = p_budget_revision_id ;
9847: /* Bug No 2482305 End */
9848:
9849: -- Delete from psb_position_accounts.
9850: DELETE psb_position_accounts
9851: WHERE budget_revision_id = p_budget_revision_id ;
9852:
9853: -- Delete from psb_position_fte.
9854: DELETE psb_position_fte