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
2607: AND FINAC_LS.LTY_CODE = 'FREE_FORM1'
2615: -- Quantity change
2616: CURSOR c_quantity_changed(cp_chr_id NUMBER,cp_major_version NUMBER) IS
2617: SELECT 'X'
2618: FROM
2619: OKC_K_LINES_B C_CLE,
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,
2637: AND ROWNUM = 1;
2638: -- Unit Cost Changed
2639: CURSOR c_get_unit_price(cp_chr_id NUMBER, cp_version NUMBER) IS
2640: SELECT 'X'
2641: FROM OKC_K_LINES_B C_CLE,
2642: OKC_K_LINES_BH H_CLE,
2643: OKC_LINE_STYLES_B C_LSE,
2644: OKL_K_LINES c_kle,
2645: OKL_K_LINES_H h_kle ,
2638: -- Unit Cost Changed
2639: CURSOR c_get_unit_price(cp_chr_id NUMBER, cp_version NUMBER) IS
2640: SELECT 'X'
2641: FROM OKC_K_LINES_B C_CLE,
2642: OKC_K_LINES_BH H_CLE,
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,