APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_ASSETS

Line 1574: from OKL_INS_ASSETS OINB

1570: l_attribute_label ak_attributes_tl.attribute_label_long%TYPE := NULL; -- 3927315
1571:
1572: CURSOR c_okl_ins_asset IS
1573: select SUM(lessor_premium) -- Smoduga fix fro bug 4238141
1574: from OKL_INS_ASSETS OINB
1575: where OINB.IPY_ID = p_ipyv_rec.ID
1576: GROUP BY OINB.IPY_ID;
1577:
1578:

Line 2569: OKL_INS_ASSETS INA,

2565: WHERE
2566: NEW_ASST.KLE_ID not in
2567: (SELECT INA.KLE_ID
2568: FROM
2569: OKL_INS_ASSETS INA,
2570: OKL_INS_POLICIES_B IPY
2571: WHERE
2572: IPY.KHR_ID = cp_chr_id
2573: AND IPY.ID = INA.IPY_ID

Line 2583: FROM OKL_INS_ASSETS INA,

2579: -- gboomina Bug 5015042 - End
2580: --- Check for termination of the fixed asset line
2581: CURSOR c_asset_termination(cp_chr_id NUMBER) IS
2582: SELECT 'X'
2583: FROM OKL_INS_ASSETS INA,
2584: OKC_K_LINES_B FINAC_CLE,
2585: OKC_LINE_STYLES_B FINAC_LS ,
2586: OKL_INS_POLICIES_B IPY
2587: WHERE FINAC_CLE.ID = INA.KLE_ID

Line 2605: OKL_INS_ASSETS INA

2601: OKC_K_ITEMS C_CIT,
2602: OKC_K_ITEMS_H H_CIT,
2603: OKC_LINE_STYLES_B C_LSE,
2604: OKL_INS_POLICIES_B IPY,
2605: OKL_INS_ASSETS INA
2606: WHERE c_cle.dnz_chr_id = cp_chr_id
2607: AND c_cle.id = c_cit.cle_id
2608: AND c_cle.lse_id = c_lse.id
2609: AND c_cit.id = h_cit.id

Line 2628: OKL_INS_ASSETS INA

2624: OKC_LINE_STYLES_B C_LSE,
2625: OKL_K_LINES c_kle,
2626: OKL_K_LINES_H h_kle ,
2627: OKL_INS_POLICIES_B IPY,
2628: OKL_INS_ASSETS INA
2629: WHERE c_cle.dnz_chr_id = cp_chr_id
2630: AND c_cle.id = h_cle.id
2631: AND c_cle.lse_id = c_lse.id
2632: AND c_cle.id = c_kle.id

Line 2913: FROM OKL_INS_ASSETS OINB

2909: WHERE id = c_khr_id ;
2910: -- get lease premium
2911: CURSOR c_okl_ins_asset IS
2912: SELECT SUM(lessor_premium)
2913: FROM OKL_INS_ASSETS OINB
2914: WHERE OINB.IPY_ID = p_ipyv_rec.ID
2915: GROUP BY OINB.IPY_ID;
2916: -- calculate total amount paid to vendor
2917: CURSOR c_total_paid(p_stm_type_id NUMBER) IS