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.

[Home] [Help]

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 1306: FROM OKL_INS_POLICIES_B IPYB

1302: l_ipyv_rec ipyv_rec_type;
1303:
1304: CURSOR c_ins_info( p_ipy_id NUMBER) IS
1305: SELECT IPYB.KHR_ID, IPYB.KLE_ID ,IPYB.OBJECT_VERSION_NUMBER, ISS_CODE, IPY_TYPE ,FACTOR_CODE
1306: FROM OKL_INS_POLICIES_B IPYB
1307: WHERE IPYB.ID = p_ipy_id;
1308: l_khr_status VARCHAR2(30) ;
1309: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1310: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;

Line 1623: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

1619:
1620:
1621: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
1622: SELECT ((INSURER_RATE * p_covered_amount )/100 )
1623: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
1624: WHERE IPYB.ipt_id = inr.ipt_id AND
1625: kle_id = p_ipyv_rec.KLE_ID and
1626: khr_id = p_ipyv_rec.KHR_ID
1627: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)

Line 2422: FROM OKL_INS_POLICIES_B

2418: -- 3976894 Modified cursor to fetch Pending policies and also
2419: -- 3976894 get the ISS_CODE in the select clause.
2420: CURSOR c_okl_ins_policies(p_contract_id NUMBER) IS
2421: SELECT ID, IPY_TYPE, ISS_CODE
2422: FROM OKL_INS_POLICIES_B
2423: WHERE KHR_ID = p_contract_id
2424: and ISS_CODE in ('ACTIVE','PENDING');
2425:
2426: BEGIN

Line 2570: OKL_INS_POLICIES_B IPY

2566: NEW_ASST.KLE_ID not in
2567: (SELECT INA.KLE_ID
2568: FROM
2569: OKL_INS_ASSETS INA,
2570: OKL_INS_POLICIES_B IPY
2571: WHERE
2572: IPY.KHR_ID = cp_chr_id
2573: AND IPY.ID = INA.IPY_ID
2574: AND IPY.ISS_CODE IN ( 'PENDING', 'ACTIVE')

Line 2586: OKL_INS_POLICIES_B IPY

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

Line 2604: OKL_INS_POLICIES_B IPY,

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

Line 2627: OKL_INS_POLICIES_B IPY,

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
2629: WHERE c_cle.dnz_chr_id = cp_chr_id
2630: AND c_cle.id = h_cle.id
2631: AND c_cle.lse_id = c_lse.id

Line 2729: FROM OKL_INS_POLICIES_B IPYB

2725: --Skgautam:4542203 : added IPYB.iss_code
2726: CURSOR c_ins_info( c_ipy_id NUMBER) IS
2727: SELECT IPYB.KHR_ID, IPYB.KLE_ID ,IPYB.OBJECT_VERSION_NUMBER, IPYB.date_from,
2728: IPYB.ipy_type,IPYB.factor_code,IPYB.IPF_CODE,IPYB.date_to,IPYB.premium,IPYB.COVERED_AMOUNT,IPYB.ISS_CODE
2729: FROM OKL_INS_POLICIES_B IPYB
2730: WHERE IPYB.ID = c_ipy_id;
2731:
2732: lx_ipyv_rec ipyv_rec_type;
2733:

Line 2933: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR

2929: WHERE name = cp_name
2930: AND language = cp_language;
2931: CURSOR c_ins_opt_premium (p_covered_amount IN NUMBER) IS
2932: SELECT ((INSURER_RATE * p_covered_amount )/100 )
2933: FROM OKL_INS_POLICIES_B IPYB , OKL_INS_RATES INR
2934: WHERE IPYB.ipt_id = inr.ipt_id AND
2935: kle_id = p_ipyv_rec.KLE_ID and
2936: khr_id = p_ipyv_rec.KHR_ID
2937: AND IPYB.date_from between inr.date_FROM and DECODE(NVL(inr.date_TO,NULL),NULL,SYSDATE, inr.date_TO)

Line 5138: FROM OKL_INS_POLICIES_B

5134: l_vld_cncl_dt VARCHAR2(1) := '?';
5135: l_cancel_pol_flag VARCHAR2(1) := 'N';
5136: CURSOR c_okl_ins_policies(p_contract_id NUMBER) IS
5137: SELECT ID, IPY_TYPE, ISS_CODE
5138: FROM OKL_INS_POLICIES_B
5139: WHERE KHR_ID = p_contract_id
5140: and ISS_CODE IN ('ACTIVE','ACCEPTED','PENDING')
5141: and IPY_TYPE = 'LEASE_POLICY'
5142: AND DATE_TO > p_cancellation_date; -- bug 4056603

Line 5145: FROM OKL_INS_POLICIES_B

5141: and IPY_TYPE = 'LEASE_POLICY'
5142: AND DATE_TO > p_cancellation_date; -- bug 4056603
5143: CURSOR c_okl_ins_quote(p_contract_id NUMBER,p_quote_id NUMBER) IS
5144: SELECT ipy_id
5145: FROM OKL_INS_POLICIES_B
5146: WHERE KHR_ID = p_contract_id
5147: AND ID = p_quote_id;
5148: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
5149: SELECT OST.STE_CODE

Line 5919: FROM OKL_INS_POLICIES_B IPYB

5915: -- schodava added Covered_amount to the cursor for Bug 4701170
5916: CURSOR c_ins_info( p_ipy_id NUMBER) IS
5917: SELECT IPYB.KHR_ID, IPYB.KLE_ID ,IPYB.OBJECT_VERSION_NUMBER, IPYB.date_from, IPYB.ipy_type,IPYB.factor_code,
5918: IPYB.COVERED_AMOUNT
5919: FROM OKL_INS_POLICIES_B IPYB
5920: WHERE IPYB.ID = p_ipy_id;
5921:
5922:
5923:

Line 5926: FROM OKL_INS_POLICIES_B IPYB

5922:
5923:
5924: CURSOR c_okl_third_party(l_khr_id NUMBER, l_cancellation_date DATE) IS
5925: SELECT ID
5926: FROM OKL_INS_POLICIES_B IPYB
5927: WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY'
5928: AND l_cancellation_date BETWEEN IPYB.date_from and IPYB.date_to;
5929:
5930: -- cursor changed to take the stream type id as the parameter, for user defined streams, bug 3924300

Line 6890: FROM OKL_INS_POLICIES_B

6886: l_params okl_execute_formula_pub.ctxt_val_tbl_type; ---+++ Effective Dated Termination ++++----
6887:
6888: CURSOR okl_ipy_rec(p_policy_id NUMBER) IS
6889: SELECT KHR_ID , KLE_ID
6890: FROM OKL_INS_POLICIES_B
6891: WHERE ID = p_policy_id;
6892:
6893: BEGIN
6894:

Line 7026: FROM OKL_INS_POLICIES_B

7022:
7023:
7024: CURSOR okl_ins_policy_id(p_contract_line NUMBER) IS
7025: SELECT id
7026: FROM OKL_INS_POLICIES_B
7027: WHERE KLE_ID = p_contract_line;
7028: p_name VARCHAR2(150) :='Credit Memo'; --bug 3923601
7029: p_lang VARCHAR2(2) := 'US' ;
7030: l_trx_type NUMBER ;

Line 7328: UPDATE OKL_INS_POLICIES_B IPYB

7324: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7325: --
7326: --
7327:
7328: UPDATE OKL_INS_POLICIES_B IPYB
7329: SET IPYB.ISU_ID = p_to_fk_id
7330: ,IPYB.object_version_number = IPYB.object_version_number + 1
7331: ,IPYB.last_update_date = SYSDATE
7332: ,IPYB.last_updated_by = arp_standard.profile.user_id

Line 7415: UPDATE OKL_INS_POLICIES_B IPYB

7411: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7412: --
7413: --
7414:
7415: UPDATE OKL_INS_POLICIES_B IPYB
7416: SET IPYB.AGENCY_SITE_ID = p_to_fk_id
7417: ,IPYB.object_version_number = IPYB.object_version_number + 1
7418: ,IPYB.last_update_date = SYSDATE
7419: ,IPYB.last_updated_by = arp_standard.profile.user_id

Line 7501: UPDATE OKL_INS_POLICIES_B IPYB

7497: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7498: --
7499: --
7500:
7501: UPDATE OKL_INS_POLICIES_B IPYB
7502: SET IPYB.INT_ID = p_to_fk_id
7503: ,IPYB.object_version_number = IPYB.object_version_number + 1
7504: ,IPYB.last_update_date = SYSDATE
7505: ,IPYB.last_updated_by = arp_standard.profile.user_id

Line 7586: UPDATE OKL_INS_POLICIES_B IPYB

7582: arp_message.set_token('TABLE_NAME','OKL_INS_POLICIES',FALSE);
7583: --
7584: --
7585:
7586: UPDATE OKL_INS_POLICIES_B IPYB
7587: SET IPYB.AGENT_SITE_ID = p_to_fk_id
7588: ,IPYB.object_version_number = IPYB.object_version_number + 1
7589: ,IPYB.last_update_date = SYSDATE
7590: ,IPYB.last_updated_by = arp_standard.profile.user_id