DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_PRODUCTS

Line 6129: okl_products pdt

6125: khr.multi_gaap_yn, pdt.reporting_pdt_id -- MGAAP 7263041
6126: FROM okc_k_headers_b CHR,
6127: okl_trx_contracts ktrx,
6128: okl_k_headers khr,
6129: okl_products pdt
6130: WHERE ktrx.khr_id_new = chr.id
6131: AND ktrx.tsu_code = 'ENTERED'
6132: AND ktrx.rbr_code is NOT NULL
6133: AND ktrx.tcn_type = 'TRBK'

Line 8259: okl_products b

8255: -- MGAAP start 7263041
8256: CURSOR c_get_reporting_pdt_id(p_chr_id IN NUMBER) IS
8257: SELECT b.reporting_pdt_id, a.multi_gaap_yn
8258: FROM okl_k_headers a,
8259: okl_products b
8260: WHERE a.ID = p_chr_id
8261: AND a.PDT_ID = b.ID;
8262:
8263: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE := null;

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

8259: okl_products b
8260: WHERE a.ID = p_chr_id
8261: AND a.PDT_ID = b.ID;
8262:
8263: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE := null;
8264: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
8265: l_current_mgaap_context VARCHAR2(10);
8266: -- MGAAP end 7263041
8267: