DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_K_LINES_B

Line 2584: OKC_K_LINES_B FINAC_CLE,

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
2588: AND FINAC_LS.LTY_CODE = 'FREE_FORM1'

Line 2600: OKC_K_LINES_B C_CLE,

2596: -- Quantity change
2597: CURSOR c_quantity_changed(cp_chr_id NUMBER,cp_major_version NUMBER) IS
2598: SELECT 'X'
2599: FROM
2600: OKC_K_LINES_B C_CLE,
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,

Line 2622: FROM OKC_K_LINES_B C_CLE,

2618: AND ROWNUM = 1;
2619: -- Unit Cost Changed
2620: CURSOR c_get_unit_price(cp_chr_id NUMBER, cp_version NUMBER) IS
2621: SELECT 'X'
2622: FROM OKC_K_LINES_B C_CLE,
2623: OKC_K_LINES_BH H_CLE,
2624: OKC_LINE_STYLES_B C_LSE,
2625: OKL_K_LINES c_kle,
2626: OKL_K_LINES_H h_kle ,

Line 2623: OKC_K_LINES_BH H_CLE,

2619: -- Unit Cost Changed
2620: CURSOR c_get_unit_price(cp_chr_id NUMBER, cp_version NUMBER) IS
2621: SELECT 'X'
2622: FROM OKC_K_LINES_B C_CLE,
2623: OKC_K_LINES_BH H_CLE,
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,