[Home] [Help]
4370: salary_type,
4371: follow_salary,
4372: period_type,
4373: process_period_type
4374: from PSB_PAY_ELEMENTS
4375: where data_extract_id = g_data_extract_id
4376: and business_group_id = g_business_group_id
4377: and ((start_date >= p_start_date) and ((start_date <= p_end_date)
4378: or (end_date is null))
6946: a.formula_id,
6947: a.effective_start_date,
6948: a.effective_end_date
6949: from PSB_PAY_ELEMENT_RATES a,
6950: PSB_PAY_ELEMENTS b
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
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,
8375: PSB_BUDGET_REVISION_POS_LINES e,
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
8408: and a.budget_revision_id = p_budget_revision_id
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
9839: WHERE pay_element_rate_id = l_br_position_rec.pay_element_rate_id;
9840:
9841: END LOOP;