DBA Data[Home] [Help]

APPS.OKE_BILLING_EVENT_PUB dependencies on OKE_K_DELIVERABLES_VL

Line 1111: From oke_k_deliverables_vl

1107: l_price NUMBER;
1108: l_price1 NUMBER;
1109: CURSOR get_unit_price is
1110: Select Unit_Price
1111: From oke_k_deliverables_vl
1112: Where Deliverable_Id = p_k_billing_event_rec.deliverable_id;
1113:
1114:
1115: BEGIN

Line 1194: From oke_k_deliverables_vl

1190: l_k_billing_event_rec k_billing_event_rec_type := p_k_billing_event_rec;
1191:
1192: Cursor Dlv_C ( P_Deliverable_Id Number ) Is
1193: Select Project_Id, K_Line_Id, Inventory_Org_id, Item_Id, Currency_Code, Quantity, Unit_Price, Description
1194: From oke_k_deliverables_vl
1195: Where Deliverable_Id = P_Deliverable_Id;
1196:
1197: CURSOR ProjNum ( C_Project_ID NUMBER ) IS
1198: SELECT segment1