DBA Data[Home] [Help]

APPS.OKL_ILS_PVT dependencies on OKL_INVOICE_FORMATS_TL

Line 10: FROM OKL_INVC_FRMT_STRMS invstr , OKL_STRM_TYPE_TL strm ,OKL_INVOICE_FORMATS_TL invf

6: FUNCTION IS_UNIQUE (p_ilsv_rec ilsv_rec_type) RETURN VARCHAR2
7: IS
8: CURSOR l_ils_csr IS
9: SELECT strm.name, invf.name
10: FROM OKL_INVC_FRMT_STRMS invstr , OKL_STRM_TYPE_TL strm ,OKL_INVOICE_FORMATS_TL invf
11: WHERE invstr.sty_id = p_ilsv_rec.sty_id
12: AND invstr.inf_id = p_ilsv_rec.inf_id
13: AND invstr.id <> NVL(p_ilsv_rec.id,-9999)
14: AND invstr.sty_id = strm.id