APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_ASSETS

Line 1593: from OKL_INS_ASSETS OINB

1589: l_attribute_label ak_attributes_tl.attribute_label_long%TYPE := NULL; -- 3927315
1590:
1591: CURSOR c_okl_ins_asset IS
1592: select SUM(lessor_premium) -- Smoduga fix fro bug 4238141
1593: from OKL_INS_ASSETS OINB
1594: where OINB.IPY_ID = p_ipyv_rec.ID
1595: GROUP BY OINB.IPY_ID;
1596:
1597:

Line 2588: OKL_INS_ASSETS INA,

2584: WHERE
2585: NEW_ASST.KLE_ID not in
2586: (SELECT INA.KLE_ID
2587: FROM
2588: OKL_INS_ASSETS INA,
2589: OKL_INS_POLICIES_B IPY
2590: WHERE
2591: IPY.KHR_ID = cp_chr_id
2592: AND IPY.ID = INA.IPY_ID

Line 2602: FROM OKL_INS_ASSETS INA,

2598: -- gboomina Bug 5015042 - End
2599: --- Check for termination of the fixed asset line
2600: CURSOR c_asset_termination(cp_chr_id NUMBER) IS
2601: SELECT 'X'
2602: FROM OKL_INS_ASSETS INA,
2603: OKC_K_LINES_B FINAC_CLE,
2604: OKC_LINE_STYLES_B FINAC_LS ,
2605: OKL_INS_POLICIES_B IPY
2606: WHERE FINAC_CLE.ID = INA.KLE_ID

Line 2624: OKL_INS_ASSETS INA

2620: OKC_K_ITEMS C_CIT,
2621: OKC_K_ITEMS_H H_CIT,
2622: OKC_LINE_STYLES_B C_LSE,
2623: OKL_INS_POLICIES_B IPY,
2624: OKL_INS_ASSETS INA
2625: WHERE c_cle.dnz_chr_id = cp_chr_id
2626: AND c_cle.id = c_cit.cle_id
2627: AND c_cle.lse_id = c_lse.id
2628: AND c_cit.id = h_cit.id

Line 2647: OKL_INS_ASSETS INA

2643: OKC_LINE_STYLES_B C_LSE,
2644: OKL_K_LINES c_kle,
2645: OKL_K_LINES_H h_kle ,
2646: OKL_INS_POLICIES_B IPY,
2647: OKL_INS_ASSETS INA
2648: WHERE c_cle.dnz_chr_id = cp_chr_id
2649: AND c_cle.id = h_cle.id
2650: AND c_cle.lse_id = c_lse.id
2651: AND c_cle.id = c_kle.id

Line 2932: FROM OKL_INS_ASSETS OINB

2928: WHERE id = c_khr_id ;
2929: -- get lease premium
2930: CURSOR c_okl_ins_asset IS
2931: SELECT SUM(lessor_premium)
2932: FROM OKL_INS_ASSETS OINB
2933: WHERE OINB.IPY_ID = p_ipyv_rec.ID
2934: GROUP BY OINB.IPY_ID;
2935: -- calculate total amount paid to vendor
2936: CURSOR c_total_paid(p_stm_type_id NUMBER) IS