DBA Data[Home] [Help]

APPS.OKL_UWQ_SEL_PKG dependencies on ASO_QUOTE_HEADERS_ALL

Line 298: FROM ASO_QUOTE_HEADERS_ALL

294: -- number
295: PROCEDURE getDtlsFromColReq IS
296: CURSOR C_getDtlsFromColReq(x_collateralReqNum NUMBER ) IS
297: SELECT quote_header_id,party_id,cust_account_id,l_contactid
298: FROM ASO_QUOTE_HEADERS_ALL
299: WHERE quote_number = x_collateralReqNum;
300: BEGIN
301: OPEN C_getDtlsFromColReq(TO_NUMBER(l_collateralreqnum));
302: FETCH C_getDtlsFromColReq INTO l_collateralId,l_partyId, l_accountCode,l_contactId;