DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_LINE_STYLES_B

Line 2585: OKC_LINE_STYLES_B FINAC_LS ,

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'
2589: AND FINAC_CLE.LSE_ID = FINAC_LS.ID

Line 2603: OKC_LINE_STYLES_B C_LSE,

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,
2605: OKL_INS_ASSETS INA
2606: WHERE c_cle.dnz_chr_id = cp_chr_id
2607: AND c_cle.id = c_cit.cle_id

Line 2624: OKC_LINE_STYLES_B C_LSE,

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,
2628: OKL_INS_ASSETS INA