DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_PRODUCTS

Line 3325: OKL_PRODUCTS B

3321: l_inc_sty_id_rep NUMBER ; -- MGAAP 7263041
3322: CURSOR check_csr(p_khr_id NUMBER) IS
3323: SELECT A.MULTI_GAAP_YN, B.REPORTING_PDT_ID
3324: FROM OKL_K_HEADERS A,
3325: OKL_PRODUCTS B
3326: WHERE A.ID = p_khr_id
3327: AND A.PDT_ID = B.ID;
3328:
3329: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

Line 3330: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

3326: WHERE A.ID = p_khr_id
3327: AND A.PDT_ID = B.ID;
3328:
3329: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
3330: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
3331:
3332: l_total_bill_accrued_rep NUMBER;
3333: l_adjustment_amount_rep NUMBER;
3334: l_sob_id NUMBER;

Line 3969: okl_products pdt

3965: SELECT khr.pdt_id pdt_id,
3966: khr.multi_gaap_yn mylti_gaap_yn, -- MGAAP
3967: pdt.reporting_pdt_id reporting_pdt_id
3968: FROM okl_k_headers_v khr,
3969: okl_products pdt
3970: WHERE khr.ID = p_khr_id
3971: AND khr.PDT_ID = pdt.ID;
3972:
3973: --smoduga..Bug 4493213 fix..08-aug-2005..start

Line 4021: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;

4017:
4018: l_strm_type_id_rep NUMBER;
4019: l_adjustment_amount_rep NUMBER;
4020: l_multi_gaap_yn okl_k_headers.multi_gaap_yn%TYPE;
4021: l_reporting_pdt_id okl_products.reporting_pdt_id%TYPE;
4022: l_sob_id NUMBER;
4023: l_total_pay_accrued_rep NUMBER;
4024: l_inc_sty_id_rep NUMBER ;
4025: