DBA Data[Home] [Help]

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKC_LINE_STYLES_B

Line 2604: OKC_LINE_STYLES_B FINAC_LS ,

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

Line 2622: OKC_LINE_STYLES_B C_LSE,

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,
2624: OKL_INS_ASSETS INA
2625: WHERE c_cle.dnz_chr_id = cp_chr_id
2626: AND c_cle.id = c_cit.cle_id

Line 2643: OKC_LINE_STYLES_B C_LSE,

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