DBA Data[Home] [Help]

APPS.OKL_TRX_CONTRACTS_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 99: FROM okl_prod_qlty_val_uv

95: WHERE id = pdt_id;
96:
97: CURSOR book_csr(p_id OKL_PRODUCTS.ID%TYPE) IS
98: SELECT quality_val, quality_name
99: FROM okl_prod_qlty_val_uv
100: WHERE pdt_id = p_id
101: AND QUALITY_NAME IN ('LEASE', 'INVESTOR');
102:
103: CURSOR tax_csr(p_id OKL_PRODUCTS.ID%TYPE) IS

Line 105: FROM okl_prod_qlty_val_uv

101: AND QUALITY_NAME IN ('LEASE', 'INVESTOR');
102:
103: CURSOR tax_csr(p_id OKL_PRODUCTS.ID%TYPE) IS
104: SELECT quality_val
105: FROM okl_prod_qlty_val_uv
106: WHERE pdt_id = p_id
107: AND QUALITY_NAME = 'TAXOWNER';
108:
109: CURSOR representation_csr(set_of_books_id OKL_TRX_CONTRACTS.set_of_books_id%TYPE) IS