APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_PAY_ELEMENT_RATES

Line 4701: from PSB_PAY_ELEMENT_RATES

4697: where position_id = l_position_id;
4698:
4699: cursor c_pay_element_rates is
4700: select *
4701: from PSB_PAY_ELEMENT_RATES
4702: where worksheet_id = p_budget_revision_id;
4703:
4704: BEGIN
4705:

Line 4945: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

4941: end loop;
4942:
4943: for c_rates_rec in c_pay_element_rates
4944: loop
4945: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
4946: (p_api_version => 1.0,
4947: p_return_status => l_return_status,
4948: p_msg_count => l_msg_count,
4949: p_msg_data => l_msg_data,

Line 6949: from PSB_PAY_ELEMENT_RATES a,

6945: a.element_value,
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

Line 9838: DELETE psb_pay_element_rates

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;
9842:

Line 9844: -- Delete from psb_pay_element_rates.

9840:
9841: END LOOP;
9842:
9843: /* Bug No 2482305 Start */
9844: -- Delete from psb_pay_element_rates.
9845: DELETE psb_pay_element_rates
9846: WHERE worksheet_id = p_budget_revision_id ;
9847: /* Bug No 2482305 End */
9848:

Line 9845: DELETE psb_pay_element_rates

9841: END LOOP;
9842:
9843: /* Bug No 2482305 Start */
9844: -- Delete from psb_pay_element_rates.
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.