APPS.OKE_BILLING_EVENT_PUB dependencies on OKE_K_BILLING_EVENTS

Line 1216: From oke_k_billing_events

1212:
1213:
1214: Cursor Qty_C ( P_Deliverable_Id Number ) Is
1215: Select Nvl(Sum( Bill_Quantity ), 0)
1216: From oke_k_billing_events
1217: Where Deliverable_Id = P_Deliverable_Id;
1218:
1219: CURSOR BillLading ( C_Deliverable_ID NUMBER ) IS
1220: SELECT di.sequence_number

Line 1236: from oke_k_billing_events e

1232:
1233:
1234: Cursor Can_qty_c(p_deliverable_id number) is
1235: select nvl(sum(bill_quantity),0)
1236: from oke_k_billing_events e
1237: where Deliverable_Id = P_Deliverable_Id
1238: and exists ( Select 'Y'
1239: from pa_events p,pa_draft_invoice_items i
1240: where p.event_id=e.pa_event_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

Line 1701: from oke_k_billing_events

1697: attribute13 ,
1698: attribute14 ,
1699: attribute15 ,
1700: initiated_flag
1701: from oke_k_billing_events
1702: where Billing_Event_Id = p_k_billing_event_rec.billing_event_id;
1703: l_bill_currency VARCHAR2(40);
1704:
1705: l_k_billing_event_rec OKE_BILLING_EVENT_PUB.k_billing_event_rec_type;

Line 2170: FROM oke_k_billing_events

2166:
2167: CURSOR cur_get_event_info (p_BILLING_EVENT_ID NUMBER)
2168: IS
2169: SELECT PA_EVENT_ID
2170: FROM oke_k_billing_events
2171: WHERE BILLING_EVENT_ID = p_BILLING_EVENT_ID;
2172: l_pa_event_id NUMBER;
2173:
2174: