DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on OKL_STREAM_BILLING_PVT

Line 4499: TRUNC((NVL (p_to_bill_date, SYSDATE) + okl_stream_billing_pvt.get_printing_lead_days(stm.khr_id)))

4495: okc_statuses_b kls
4496: WHERE TRUNC(ste.stream_element_date) >=
4497: TRUNC(NVL (p_from_bill_date, ste.stream_element_date))
4498: AND TRUNC(ste.stream_element_date) <=
4499: TRUNC((NVL (p_to_bill_date, SYSDATE) + okl_stream_billing_pvt.get_printing_lead_days(stm.khr_id)))
4500: AND ste.amount <> 0
4501: AND stm.id = ste.stm_id
4502: AND ste.date_billed IS NULL
4503: AND stm.active_yn = 'Y'