DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_PRODUCTS

Line 7790: okl_products pdt

7786: khr.multi_gaap_yn, pdt.reporting_pdt_id -- MGAAP 7263041
7787: FROM okc_k_headers_b CHR,
7788: okl_trx_contracts ktrx,
7789: okl_k_headers khr,
7790: okl_products pdt
7791: WHERE ktrx.khr_id_new = chr.id
7792: AND ktrx.tsu_code = 'ENTERED'
7793: AND ktrx.rbr_code is NOT NULL
7794: AND ktrx.tcn_type = 'TRBK'

Line 9933: okl_products b

9929: -- MGAAP start 7263041
9930: CURSOR c_get_reporting_pdt_id(p_chr_id IN NUMBER) IS
9931: SELECT b.reporting_pdt_id, a.multi_gaap_yn
9932: FROM okl_k_headers a,
9933: okl_products b
9934: WHERE a.ID = p_chr_id
9935: AND a.PDT_ID = b.ID;
9936:
9937: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE := null;

Line 9937: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE := null;

9933: okl_products b
9934: WHERE a.ID = p_chr_id
9935: AND a.PDT_ID = b.ID;
9936:
9937: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE := null;
9938: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
9939: l_current_mgaap_context VARCHAR2(10);
9940: -- MGAAP end 7263041
9941: