[Home] [Help]
4681: where budget_revision_id = p_budget_revision_id;
4682:
4683: cursor c_assignments is
4684: select *
4685: from PSB_POSITION_ASSIGNMENTS
4686: where worksheet_id = p_budget_revision_id
4687: and assignment_type = 'ELEMENT';
4688:
4689: cursor c_accdistr is
6922: element_value_type,
6923: element_value,
6924: effective_start_date,
6925: effective_end_date
6926: from PSB_POSITION_ASSIGNMENTS
6927: where ((worksheet_id = g_global_budget_revision_id) or (worksheet_id is null))
6928: and currency_code = g_func_currency
6929: and assignment_type = 'ELEMENT'
6930: and (((effective_start_date <= l_end_date)
6951: where (a.worksheet_id is null or a.worksheet_id = g_global_budget_revision_id)
6952: and a.currency_code = g_func_currency
6953: and exists
6954: (select 1
6955: from PSB_POSITION_ASSIGNMENTS c
6956: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)
6957: and ((c.worksheet_id = g_global_budget_revision_id) or (c.worksheet_id is null))
6958: and c.currency_code = g_func_currency
6959: and (((c.effective_start_date <= l_end_date)
6982: attribute_id,
6983: -- Fixed bug # 3683644
6984: FND_NUMBER.canonical_to_number(attribute_value) attribute_value,
6985: attribute_value_id
6986: from PSB_POSITION_ASSIGNMENTS
6987: where attribute_id in (PSB_WS_POS1.g_default_wklyhrs_id, PSB_WS_POS1.g_fte_id)
6988: and (( worksheet_id = g_global_budget_revision_id) or (worksheet_id is null))
6989: and assignment_type = 'ATTRIBUTE'
6990: and (((effective_start_date <= l_end_date)
8319: b.name,
8320: b.grade_step
8321: from PSB_POSITIONS a,
8322: PSB_PAY_ELEMENT_OPTIONS b,
8323: PSB_POSITION_ASSIGNMENTS c
8324: where exists
8325: (select 1
8326: from PSB_BUDGET_POSITIONS d,
8327: PSB_SET_RELATIONS e
8338: cursor c_SalaryNeq is
8339: select a.name,
8340: a.grade_step
8341: from PSB_PAY_ELEMENT_OPTIONS a,
8342: PSB_POSITION_ASSIGNMENTS b
8343: where a.pay_element_option_id = b.pay_element_option_id
8344: and b.pay_element_option_id <> p_pay_element_option_id
8345: and b.pay_element_id = p_pay_element_id
8346: and b.position_id = p_position_id;
9441: End Loop;
9442:
9443: /* Bug No 2482305 Start */
9444: -- Added to remove the worksheet specific position records for deleted positions
9445: delete from PSB_POSITION_ASSIGNMENTS pa
9446: where pa.position_id = l_position_id
9447: and pa.worksheet_id = p_budget_revision_id
9448: and pa.data_extract_id = g_data_extract_id;
9449: /* Bug No 2482305 End */
9679:
9680: CURSOR l_br_position_csr
9681: IS
9682: SELECT position_assignment_id, pay_element_rate_id
9683: FROM psb_position_assignments
9684: WHERE worksheet_id = p_budget_revision_id
9685: AND data_extract_id = l_data_extract_id
9686: GROUP BY position_assignment_id, pay_element_rate_id;
9687:
9754: --
9755: /*For Bug No ; 1527423 Start*/
9756: -- Delete from psb_positions
9757: FOR l_br_pos_csr_rec IN l_br_pos_csr LOOP
9758: DELETE psb_position_assignments
9759: WHERE position_id = l_br_pos_csr_rec.position_id;
9760:
9761: DELETE psb_positions
9762: WHERE position_id = l_br_pos_csr_rec.position_id;
9829: END IF;
9830:
9831: For l_br_position_rec In l_br_position_csr
9832: LOOP
9833: -- Delete from psb_position_assignments.
9834: DELETE psb_position_assignments
9835: WHERE position_assignment_id = l_br_position_rec.position_assignment_id;
9836:
9837: -- Delete from psb_pay_elements_rates.
9830:
9831: For l_br_position_rec In l_br_position_csr
9832: LOOP
9833: -- Delete from psb_position_assignments.
9834: DELETE psb_position_assignments
9835: WHERE position_assignment_id = l_br_position_rec.position_assignment_id;
9836:
9837: -- Delete from psb_pay_elements_rates.
9838: DELETE psb_pay_element_rates