APPS.OKL_AM_SHIPPING_INSTR_PVT dependencies on DUAL

Line 93: SELECT SYSDATE INTO l_sysdate FROM DUAL;

89: END IF;
90:
91:
92: -- SECHAWLA Bug # 2667636 : using sysdate as transaction date for currency conversion routines
93: SELECT SYSDATE INTO l_sysdate FROM DUAL;
94:
95:
96: -- Get the khr_id and kle_id and floor price for the asset being shipped
97: OPEN okl_get_khr_kle_csr(lp_rasv_rec.art_id);

Line 619: SELECT SYSDATE INTO lp_rasv_rec.date_shipping_instructions_sen FROM DUAL;

615: -- Set the date_sent if not set
616: IF lp_rasv_rec.date_shipping_instructions_sen IS NULL
617: OR lp_rasv_rec.date_shipping_instructions_sen = OKL_API.G_MISS_DATE THEN
618:
619: SELECT SYSDATE INTO lp_rasv_rec.date_shipping_instructions_sen FROM DUAL;
620:
621: END IF;
622:
623: -- Call the update