APPS.OKE_BILLING_EVENT_PUB dependencies on WSH_DOCUMENT_INSTANCES

Line 1221: FROM wsh_document_instances di

1217: Where Deliverable_Id = P_Deliverable_Id;
1218:
1219: CURSOR BillLading ( C_Deliverable_ID NUMBER ) IS
1220: SELECT di.sequence_number
1221: FROM wsh_document_instances di
1222: , wsh_delivery_legs dl
1223: , wsh_delivery_details dd
1224: , wsh_delivery_assignments da
1225: WHERE dd.source_code = 'OKE'

Line 1270: L_Bill_Lading WSH_DOCUMENT_INSTANCES.SEQUENCE_NUMBER%TYPE;

1266: L_Org_Name Varchar2(240);
1267: L_Curr_Code Varchar2(30);
1268: L_Round_Unit Number;
1269: L_Conversion_Type Varchar2(150);
1270: L_Bill_Lading WSH_DOCUMENT_INSTANCES.SEQUENCE_NUMBER%TYPE;
1271: L_Unit_Price Number;
1272: L_Amount Number;
1273: L_Revenue_Amount Number;
1274: L_Line_Num Varchar2(150);