APPS.OKL_STREAMS_UTIL dependencies on OKL_PRODUCTS

Line 894: FROM okl_k_headers_full_v khr, okl_products pdt

890: IS
891:
892: CURSOR cntrct_csr (l_khr_id NUMBER)IS
893: SELECT pdt.reporting_pdt_id, khr.start_date
894: FROM okl_k_headers_full_v khr, okl_products pdt
895: WHERE khr.id = l_khr_id
896: AND khr.pdt_id = pdt.id;
897:
898: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 1000: FROM okl_k_headers_full_v khr, okl_products pdt

996: IS
997:
998: CURSOR cntrct_csr (l_khr_id NUMBER)IS
999: SELECT pdt.reporting_pdt_id, khr.start_date
1000: FROM okl_k_headers_full_v khr, okl_products pdt
1001: WHERE khr.id = l_khr_id
1002: AND khr.pdt_id = pdt.id;
1003:
1004: CURSOR pry_sty_csr (l_pdt_id NUMBER, l_contract_start_date DATE) IS

Line 1409: FROM okl_k_headers_full_v khr, okl_products pdt

1405: IS
1406:
1407: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1408: SELECT pdt.reporting_pdt_id, khr.start_date
1409: FROM okl_k_headers_full_v khr, okl_products pdt
1410: WHERE khr.id = l_khr_id
1411: AND khr.pdt_id = pdt.id;
1412:
1413: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1514: FROM okl_k_headers_full_v khr, okl_products pdt

1510: IS
1511:
1512: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1513: SELECT pdt.reporting_pdt_id, khr.start_date
1514: FROM okl_k_headers_full_v khr, okl_products pdt
1515: WHERE khr.id = l_khr_id
1516: AND khr.pdt_id = pdt.id;
1517:
1518: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1623: FROM okl_k_headers_full_v khr, okl_products pdt

1619: IS
1620:
1621: CURSOR cntrct_csr (l_khr_id NUMBER)IS
1622: SELECT pdt.reporting_pdt_id, khr.start_date
1623: FROM okl_k_headers_full_v khr, okl_products pdt
1624: WHERE khr.id = l_khr_id
1625: AND khr.pdt_id = pdt.id;
1626:
1627: CURSOR dep_sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS

Line 1849: okl_products_v pdt,

1845: SELECT
1846: gts.pricing_engine
1847: FROM
1848: okl_k_headers khr,
1849: okl_products_v pdt,
1850: okl_ae_tmpt_sets_v aes,
1851: OKL_ST_GEN_TMPT_SETS gts
1852: WHERE
1853: khr.pdt_id = pdt.id AND

Line 1901: okl_products_v pdt,

1897: SELECT
1898: gts.name
1899: FROM
1900: okl_k_headers khr,
1901: okl_products_v pdt,
1902: okl_ae_tmpt_sets_v aes,
1903: OKL_ST_GEN_TMPT_SETS gts
1904: WHERE
1905: khr.pdt_id = pdt.id AND