APPS.PSB_PAY_ELEMENT_RATES_PVT dependencies on PSB_PAY_ELEMENT_RATES_S

Line 256: UPDATE psb_pay_element_rates SET

252:
253: p_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- API body
256: UPDATE psb_pay_element_rates SET
257: EFFECTIVE_START_DATE = DECODE(P_EFFECTIVE_START_DATE, FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, P_EFFECTIVE_START_DATE),
258: EFFECTIVE_END_DATE = DECODE(P_EFFECTIVE_END_DATE, FND_API.G_MISS_DATE, EFFECTIVE_END_DATE, P_EFFECTIVE_END_DATE),
259: ELEMENT_VALUE_TYPE = P_ELEMENT_VALUE_TYPE ,
260: ELEMENT_VALUE = P_ELEMENT_VALUE ,

Line 724: select psb_pay_element_rates_s.nextval RateID

720: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Element_Rates';
721: l_api_version CONSTANT NUMBER := 1.0;
722:
723: cursor c_Seq is
724: select psb_pay_element_rates_s.nextval RateID
725: from dual;
726:
727: cursor c_Rates is
728: select pay_element_rate_id,