APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_POSITION_COSTS

Line 4674: from PSB_POSITION_COSTS

4670:
4671: cursor c_costs is
4672: select position_element_line_id, position_id, pay_element_id,
4673: element_cost, start_date, end_date, currency_code
4674: from PSB_POSITION_COSTS
4675: where budget_revision_id = p_budget_revision_id;
4676:
4677: cursor c_distributions is
4678: select position_account_line_id, position_id, code_combination_id,

Line 5728: -- defined. However element cost is required in psb_position_costs table.

5724:
5725: end loop; -- element assignments
5726:
5727: -- Bug#3340060: Element cost will be null if an element does not have rates
5728: -- defined. However element cost is required in psb_position_costs table.
5729: -- The following will address this rare scenario.
5730: /* if l_element_assigned then */
5731: IF l_element_assigned AND l_element_cost IS NOT NULL THEN
5732:

Line 8350: from PSB_POSITION_COSTS a

8346: and b.position_id = p_position_id;
8347:
8348: cursor c_SumAll is
8349: select sum(nvl(a.element_cost, 0)) Sum_Elem
8350: from PSB_POSITION_COSTS a
8351: where exists
8352: (select 1
8353: from PSB_BUDGET_REVISION_POSITIONS c,
8354: PSB_BUDGET_REVISION_POS_LINES d,

Line 8370: from PSB_POSITION_COSTS a,

8366: and a.budget_revision_id = p_budget_revision_id;
8367:
8368: cursor c_SumAll_Salary is
8369: select sum(nvl(a.element_cost, 0)) Sum_Elem
8370: from PSB_POSITION_COSTS a,
8371: PSB_PAY_ELEMENTS c
8372: where exists
8373: (select 1
8374: from PSB_BUDGET_REVISION_POSITIONS d,

Line 8395: from PSB_POSITION_COSTS a

8391: and c.data_extract_id = g_data_extract_id;
8392:
8393: cursor c_Sum is
8394: select sum(nvl(a.element_cost, 0)) Sum_Elem
8395: from PSB_POSITION_COSTS a
8396: where a.currency_code = p_currency_code
8397: and a.pay_element_id = p_pay_element_id
8398: and a.position_id = p_position_id
8399: and a.budget_revision_id = p_budget_revision_id;

Line 8403: from PSB_POSITION_COSTS a,

8399: and a.budget_revision_id = p_budget_revision_id;
8400:
8401: cursor c_Sum_Salary is
8402: select sum(nvl(a.element_cost, 0)) Sum_Elem
8403: from PSB_POSITION_COSTS a,
8404: PSB_PAY_ELEMENTS c
8405: where a.currency_code = p_currency_code
8406: and a.pay_element_id = c.pay_element_id
8407: and a.position_id = p_position_id

Line 9857: -- Delete from psb_position_costs

9853: -- Delete from psb_position_fte.
9854: DELETE psb_position_fte
9855: WHERE budget_revision_id = p_budget_revision_id ;
9856:
9857: -- Delete from psb_position_costs
9858: DELETE psb_position_costs
9859: WHERE budget_revision_id = p_budget_revision_id ;
9860:
9861: -- Delete from psb_ws_submit_comments.

Line 9858: DELETE psb_position_costs

9854: DELETE psb_position_fte
9855: WHERE budget_revision_id = p_budget_revision_id ;
9856:
9857: -- Delete from psb_position_costs
9858: DELETE psb_position_costs
9859: WHERE budget_revision_id = p_budget_revision_id ;
9860:
9861: -- Delete from psb_ws_submit_comments.
9862: DELETE psb_ws_submit_comments