DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 1906: FROM okl_invoice_formats_v

1902:
1903:
1904: CURSOR chk_inv_format_csr(p_invoice_format_id IN NUMBER) IS
1905: SELECT 'Y'
1906: FROM okl_invoice_formats_v
1907: WHERE id = p_invoice_format_id
1908: AND TRUNC(SYSDATE) between NVL(start_date, TRUNC(SYSDATE))
1909: AND NVL(end_date,TRUNC(SYSDATE));
1910:

Line 7222: FROM okl_invoice_formats_v

7218: lp_rulv_temp_rec Okl_Rule_Pub.rulv_rec_type;
7219:
7220: CURSOR invoice_format_csr(p_invoice_format_id IN NUMBER) IS
7221: SELECT name
7222: FROM okl_invoice_formats_v
7223: WHERE ID = p_invoice_format_id;
7224:
7225: invoice_format_rec invoice_format_csr%ROWTYPE;
7226: