APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_PRODUCTS

Line 1188: OKL_PRODUCTS B

1184: CURSOR check_csr(p_chr_id NUMBER) IS
1185: SELECT A.MULTI_GAAP_YN,
1186: B.REPORTING_PDT_ID
1187: FROM OKL_K_HEADERS A,
1188: OKL_PRODUCTS B
1189: WHERE A.ID = p_chr_id
1190: AND A.PDT_ID = B.ID;
1191:
1192: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

Line 1193: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

1189: WHERE A.ID = p_chr_id
1190: AND A.PDT_ID = B.ID;
1191:
1192: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
1193: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
1194: -- MGAAP start 7263041
1195:
1196: --Bug# 9191475
1197: lx_trxnum_tbl OKL_GENERATE_ACCRUALS_PVT.trxnum_tbl_type;

Line 1671: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE) IS

1667: l_msg_data VARCHAR2(2000);
1668: l_currency_code okl_txl_cntrct_lns.currency_code%TYPE;
1669:
1670:
1671: CURSOR Product_csr (p_contract_id IN okl_products_v.id%TYPE) IS
1672: SELECT pdt.id product_id
1673: ,pdt.name product_name
1674: ,khr.sts_code contract_status
1675: ,khr.start_date start_date

Line 1682: FROM okl_products_v pdt

1678: ,khr.currency_conversion_rate currency_conversion_rate
1679: ,khr.currency_conversion_type currency_conversion_type
1680: ,khr.currency_conversion_date currency_conversion_date
1681: ,khr.scs_code
1682: FROM okl_products_v pdt
1683: ,okl_k_headers_full_v khr
1684: WHERE khr.id = p_contract_id
1685: AND khr.pdt_id = pdt.id;
1686:

Line 1690: FROM OKL_PRODUCTS_V

1686:
1687: -- Get the product type
1688: CURSOR l_product_type_csr ( p_pdt_id IN NUMBER) IS
1689: SELECT description
1690: FROM OKL_PRODUCTS_V
1691: WHERE id = p_pdt_id;
1692:
1693: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
1694: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

Line 10761: l_reporting_product OKL_PRODUCTS_V.NAME%TYPE;

10757: l_pdt_date DATE;
10758: l_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
10759: l_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
10760: l_rep_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
10761: l_reporting_product OKL_PRODUCTS_V.NAME%TYPE;
10762: l_no_data_found BOOLEAN;
10763: l_rep_pdt_id NUMBER;
10764: l_rep_deal_type okl_product_parameters_v.deal_type%TYPE;
10765: l_tax_owner Varchar2(150);