APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_POSITION_FTE

Line 4668: from psb_position_fte

4664:
4665: cursor c_fte is
4666: select position_fte_line_id, position_id, start_date,
4667: end_date, fte
4668: from psb_position_fte
4669: where budget_revision_id = p_budget_revision_id;
4670:
4671: cursor c_costs is
4672: select position_element_line_id, position_id, pay_element_id,

Line 5197: FROM psb_position_fte

5193: l_revised_fte NUMBER;
5194: --
5195: CURSOR l_base_fte_csr IS
5196: SELECT base_line_version, position_fte_line_id, start_date, end_date, fte
5197: FROM psb_position_fte
5198: WHERE position_id = p_position_id
5199: AND NVL (hr_budget_id, -1) = NVL (p_hr_budget_id, -1)
5200: AND base_line_version IN ('O', 'C')
5201: AND budget_revision_id IS NULL

Line 5213: FROM psb_position_fte

5209: );
5210: --
5211: CURSOR l_rev_fte_csr IS
5212: SELECT position_fte_line_id, start_date, end_date, fte
5213: FROM psb_position_fte
5214: WHERE position_id = p_position_id
5215: AND NVL (hr_budget_id, -1) = NVL (p_hr_budget_id, -1)
5216: AND budget_revision_id = p_budget_revision_id
5217: AND (

Line 7016: from PSB_POSITION_FTE

7012: and brp.revision_value is not null;
7013:
7014: cursor c_current_fte is
7015: select start_date, end_date, fte
7016: from PSB_POSITION_FTE
7017: where position_id = p_position_id
7018: and nvl(hr_budget_id, -1) = nvl(g_hr_budget_id, -1)
7019: and base_line_version = 'C'
7020: and ((start_date between p_revision_start_date and p_revision_end_date)

Line 8831: from PSB_POSITION_FTE a

8827: where constraint_id = p_constraint_id;
8828:
8829: cursor c_SumAll is
8830: select sum(nvl(a.fte, 0)) Sum_FTE
8831: from PSB_POSITION_FTE a
8832: where exists
8833: (select 1
8834: from PSB_BUDGET_REVISION_POSITIONS c,
8835: PSB_BUDGET_REVISION_POS_LINES d,

Line 8848: from PSB_POSITION_FTE

8844: and a.budget_revision_id = p_budget_revision_id;
8845:
8846: cursor c_Sum is
8847: select sum(nvl(fte, 0)) Sum_FTE
8848: from PSB_POSITION_FTE
8849: where position_id = p_position_id
8850: and budget_revision_id = p_budget_revision_id;
8851:
8852: BEGIN

Line 9853: -- Delete from psb_position_fte.

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
9855: WHERE budget_revision_id = p_budget_revision_id ;
9856:
9857: -- Delete from psb_position_costs

Line 9854: DELETE psb_position_fte

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
9855: WHERE budget_revision_id = p_budget_revision_id ;
9856:
9857: -- Delete from psb_position_costs
9858: DELETE psb_position_costs