DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_LINES_B

Line 2603: OKC_K_LINES_B FINAC_CLE,

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'

Line 2619: OKC_K_LINES_B C_CLE,

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,

Line 2641: FROM OKC_K_LINES_B C_CLE,

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 ,

Line 2642: OKC_K_LINES_BH H_CLE,

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,