eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INSURANCE_POLICIES_PVT dependencies on OKL_INS_POLICIES_B

Line 779: FROM OKL_INS_POLICIES_B IPYB ,

775: l_org NUMBER;
776:
777: CURSOR c_vendor_info (p_kle_id NUMBER ) IS --bug 4146178
778: SELECT PV.VENDOR_ID VENDOR_ID,PV.VENDOR_NAME VENDOR_NAME,CHR.AUTHORING_ORG_ID ORG_ID
779: FROM OKL_INS_POLICIES_B IPYB ,
780: OKC_K_HEADERS_B CHR,
781: PO_VENDORS PV
782: WHERE IPYB.KLE_ID = p_kle_id
783: AND CHR.ID = IPYB.KHR_ID

Line 1325: FROM OKL_INS_POLICIES_B IPYB

1321: l_ipyv_rec ipyv_rec_type;
1322:
1323: CURSOR c_ins_info( p_ipy_id NUMBER) IS
1324: SELECT IPYB.KHR_ID, IPYB.KLE_ID ,IPYB.OBJECT_VERSION_NUMBER, ISS_CODE, IPY_TYPE ,FACTOR_CODE
1325: FROM OKL_INS_POLICIES_B IPYB
1326: WHERE IPYB.ID = p_ipy_id;
1327: l_khr_status VARCHAR2(30) ;
1328: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1329: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 1642: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

1638:
1639:
1640: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
1641: SELECT ((INSURER_RATE * p_covered_amount )/100 )
1642: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
1643: WHERE IPYB.ipt_id = inr.ipt_id AND
1644: kle_id = p_ipyv_rec.KLE_ID and
1645: khr_id = p_ipyv_rec.KHR_ID
1646: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)

Line 2441: FROM OKL_INS_POLICIES_B

2437: -- 3976894 Modified cursor to fetch Pending policies and also
2438: -- 3976894 get the ISS_CODE in the select clause.
2439: CURSOR c_okl_ins_policies(p_contract_id NUMBER) IS
2440: SELECT ID, IPY_TYPE, ISS_CODE
2441: FROM OKL_INS_POLICIES_B
2442: WHERE KHR_ID = p_contract_id
2443: and ISS_CODE in ('ACTIVE','PENDING');
2444:
2445: BEGIN

Line 2589: OKL_INS_POLICIES_B IPY

2585: NEW_ASST.KLE_ID not in
2586: (SELECT INA.KLE_ID
2587: FROM
2588: OKL_INS_ASSETS INA,
2589: OKL_INS_POLICIES_B IPY
2590: WHERE
2591: IPY.KHR_ID = cp_chr_id
2592: AND IPY.ID = INA.IPY_ID
2593: AND IPY.ISS_CODE IN ( 'PENDING', 'ACTIVE')

Line 2605: OKL_INS_POLICIES_B IPY

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
2609: AND FINAC_CLE.STS_CODE <> 'BOOKED'

Line 2623: OKL_INS_POLICIES_B IPY,

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
2627: AND c_cle.lse_id = c_lse.id

Line 2646: OKL_INS_POLICIES_B IPY,

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
2648: WHERE c_cle.dnz_chr_id = cp_chr_id
2649: AND c_cle.id = h_cle.id
2650: AND c_cle.lse_id = c_lse.id

Line 2748: FROM OKL_INS_POLICIES_B IPYB

2744: --Skgautam:4542203 : added IPYB.iss_code
2745: CURSOR c_ins_info( c_ipy_id NUMBER) IS
2746: SELECT IPYB.KHR_ID, IPYB.KLE_ID ,IPYB.OBJECT_VERSION_NUMBER, IPYB.date_from,
2747: IPYB.ipy_type,IPYB.factor_code,IPYB.IPF_CODE,IPYB.date_to,IPYB.premium,IPYB.COVERED_AMOUNT,IPYB.ISS_CODE
2748: FROM OKL_INS_POLICIES_B IPYB
2749: WHERE IPYB.ID = c_ipy_id;
2750:
2751: lx_ipyv_rec ipyv_rec_type;
2752:

Line 2952: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

2948: WHERE name = cp_name
2949: AND language = cp_language;
2950: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
2951: SELECT ((INSURER_RATE * p_covered_amount )/100 )
2952: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
2953: WHERE IPYB.ipt_id = inr.ipt_id AND
2954: kle_id = p_ipyv_rec.KLE_ID and
2955: khr_id = p_ipyv_rec.KHR_ID
2956: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)

Line 5131: FROM OKL_INS_POLICIES_B

5127: l_vld_cncl_dt VARCHAR2(1) := '?';
5128: l_cancel_pol_flag VARCHAR2(1) := 'N';
5129: CURSOR c_okl_ins_policies(p_contract_id NUMBER) IS
5130: SELECT ID, IPY_TYPE, ISS_CODE
5131: FROM OKL_INS_POLICIES_B
5132: WHERE KHR_ID = p_contract_id
5133: and ISS_CODE IN ('ACTIVE','ACCEPTED','PENDING')
5134: and IPY_TYPE = 'LEASE_POLICY'
5135: AND DATE_TO > p_cancellation_date; -- bug 4056603

Line 5138: FROM OKL_INS_POLICIES_B

5134: and IPY_TYPE = 'LEASE_POLICY'
5135: AND DATE_TO > p_cancellation_date; -- bug 4056603
5136: CURSOR c_okl_ins_quote(p_contract_id NUMBER,p_quote_id NUMBER) IS
5137: SELECT ipy_id
5138: FROM OKL_INS_POLICIES_B
5139: WHERE KHR_ID = p_contract_id
5140: AND ID = p_quote_id;
5141: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
5142: SELECT OST.STE_CODE

Line 5912: FROM OKL_INS_POLICIES_B IPYB

5908: -- schodava added Covered_amount to the cursor for Bug 4701170
5909: CURSOR c_ins_info( p_ipy_id NUMBER) IS
5910: SELECT IPYB.KHR_ID, IPYB.KLE_ID ,IPYB.OBJECT_VERSION_NUMBER, IPYB.date_from, IPYB.ipy_type,IPYB.factor_code,
5911: IPYB.COVERED_AMOUNT
5912: FROM OKL_INS_POLICIES_B IPYB
5913: WHERE IPYB.ID = p_ipy_id;
5914:
5915:
5916:

Line 5919: FROM OKL_INS_POLICIES_B IPYB

5915:
5916:
5917: CURSOR c_okl_third_party(l_khr_id NUMBER, l_cancellation_date DATE) IS
5918: SELECT ID
5919: FROM OKL_INS_POLICIES_B IPYB
5920: WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY'
5921: AND l_cancellation_date BETWEEN IPYB.date_from and IPYB.date_to;
5922:
5923: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300

Line 6883: FROM OKL_INS_POLICIES_B

6879: l_params okl_execute_formula_pub.ctxt_val_tbl_type; ---+++ Effective Dated Termination ++++----
6880:
6881: CURSOR okl_ipy_rec(p_policy_id NUMBER) IS
6882: SELECT KHR_ID , KLE_ID
6883: FROM OKL_INS_POLICIES_B
6884: WHERE ID = p_policy_id;
6885:
6886: BEGIN
6887:

Line 7019: FROM OKL_INS_POLICIES_B

7015:
7016:
7017: CURSOR okl_ins_policy_id(p_contract_line NUMBER) IS
7018: SELECT id
7019: FROM OKL_INS_POLICIES_B
7020: WHERE KLE_ID = p_contract_line;
7021: p_name VARCHAR2(150) :='Credit Memo'; --bug 3923601
7022: p_lang VARCHAR2(2) := 'US' ;
7023: l_trx_type NUMBER ;

Line 7321: UPDATE OKL_INS_POLICIES_B IPYB

7317: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7318: --
7319: --
7320:
7321: UPDATE OKL_INS_POLICIES_B IPYB
7322: SET IPYB.ISU_ID = p_to_fk_id
7323: ,IPYB.object_version_number = IPYB.object_version_number + 1
7324: ,IPYB.last_update_date = SYSDATE
7325: ,IPYB.last_updated_by = arp_standard.profile.user_id

Line 7408: UPDATE OKL_INS_POLICIES_B IPYB

7404: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7405: --
7406: --
7407:
7408: UPDATE OKL_INS_POLICIES_B IPYB
7409: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
7410: ,IPYB.object_version_number = IPYB.object_version_number + 1
7411: ,IPYB.last_update_date = SYSDATE
7412: ,IPYB.last_updated_by = arp_standard.profile.user_id

Line 7494: UPDATE OKL_INS_POLICIES_B IPYB

7490: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7491: --
7492: --
7493:
7494: UPDATE OKL_INS_POLICIES_B IPYB
7495: SET IPYB.INT_ID = p_to_fk_id
7496: ,IPYB.object_version_number = IPYB.object_version_number + 1
7497: ,IPYB.last_update_date = SYSDATE
7498: ,IPYB.last_updated_by = arp_standard.profile.user_id

Line 7579: UPDATE OKL_INS_POLICIES_B IPYB

7575: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7576: --
7577: --
7578:
7579: UPDATE OKL_INS_POLICIES_B IPYB
7580: SET IPYB.AGENT_SITE_ID = p_to_fk_id
7581: ,IPYB.object_version_number = IPYB.object_version_number + 1
7582: ,IPYB.last_update_date = SYSDATE
7583: ,IPYB.last_updated_by = arp_standard.profile.user_id