DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_PRODUCTS

Line 3306: OKL_PRODUCTS B

3302: l_inc_sty_id_rep NUMBER ; -- MGAAP 7263041
3303: CURSOR check_csr(p_khr_id NUMBER) IS
3304: SELECT A.MULTI_GAAP_YN, B.REPORTING_PDT_ID
3305: FROM OKL_K_HEADERS A,
3306: OKL_PRODUCTS B
3307: WHERE A.ID = p_khr_id
3308: AND A.PDT_ID = B.ID;
3309:
3310: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

Line 3311: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

3307: WHERE A.ID = p_khr_id
3308: AND A.PDT_ID = B.ID;
3309:
3310: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
3311: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
3312:
3313: l_total_bill_accrued_rep NUMBER;
3314: l_adjustment_amount_rep NUMBER;
3315: l_sob_id NUMBER;

Line 3944: okl_products pdt

3940: SELECT khr.pdt_id pdt_id,
3941: khr.multi_gaap_yn mylti_gaap_yn, -- MGAAP
3942: pdt.reporting_pdt_id reporting_pdt_id
3943: FROM okl_k_headers_v khr,
3944: okl_products pdt
3945: WHERE khr.ID = p_khr_id
3946: AND khr.PDT_ID = pdt.ID;
3947:
3948: --smoduga..Bug 4493213 fix..08-aug-2005..start

Line 3996: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;

3992:
3993: l_strm_type_id_rep NUMBER;
3994: l_adjustment_amount_rep NUMBER;
3995: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
3996: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
3997: l_sob_id NUMBER;
3998: l_total_pay_accrued_rep NUMBER;
3999: l_inc_sty_id_rep NUMBER ;
4000: