DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on DUAL

Line 270: FROM DUAL

266: AND PROJECT_ID IS NOT NULL;
267:
268: CURSOR C (P_ID NUMBER, P_ID1 NUMBER, P_ID2 NUMBER) IS
269: SELECT 'X'
270: FROM DUAL
271: WHERE P_ID IN (
272: SELECT P.Project_ID
273: FROM pa_projects_all p
274: WHERE p.Project_ID IN (SELECT To_Number(sub_project_id)

Line 1569: Select oke_k_billing_events_s.nextval into l_event_id from dual;

1565: l_k_billing_event_rec.bill_unit_price:= l_bill_unit_price;
1566: l_k_billing_event_rec.REVENUE_AMOUNT:= l_REVENUE_AMOUNT;
1567: l_k_billing_event_rec.BILL_EXCHANGE_RATE:= l_exchange_rate;
1568:
1569: Select oke_k_billing_events_s.nextval into l_event_id from dual;
1570: l_k_billing_event_rec.BILLING_EVENT_ID:= l_event_id;
1571: OKE_DELIVERABLE_BILLING_PVT.Insert_Billing_Info
1572: ( P_Deliverable_Id => l_k_billing_event_rec.DELIVERABLE_ID
1573: , P_Billing_Event_Id => l_k_billing_event_rec.BILLING_EVENT_ID