23: BEGIN
24:
25: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
26:
27: -- Bill_Rate_Sch_ID should be from the sequence PA_STD_BILL_SCH_S next value
28: SELECT PA_STD_BILL_SCH_S.NextVal
29: INTO l_Bill_Rate_Sch_ID
30: FROM DUAL;
31:
24:
25: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
26:
27: -- Bill_Rate_Sch_ID should be from the sequence PA_STD_BILL_SCH_S next value
28: SELECT PA_STD_BILL_SCH_S.NextVal
29: INTO l_Bill_Rate_Sch_ID
30: FROM DUAL;
31:
32: -- Derive the Org_ID value from PA_Implemenatations table