APPS.OKL_INS_QUOTE_PVT dependencies on OKL_INS_POLICIES_B

Line 217: FROM OKL_INS_POLICIES_B

213: l_api_name CONSTANT VARCHAR2(30) := 'crt_lseapp_thrdprt_ins';
214: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
215: CURSOR third_prty_exist(p_lapp_id IN NUMBER)IS
216: SELECT 'x'
217: FROM OKL_INS_POLICIES_B
218: WHERE lease_application_id = p_lapp_id
219: AND IPY_TYPE = 'THIRD_PARTY_POLICY'
220: AND KHR_ID IS NULL -- not a contract yet
221: AND TRUNC(nvl(DATE_TO,SYSDATE)) > TRUNC(SYSDATE);

Line 373: FROM OKL_INS_POLICIES_B

369: IS
370: SELECT ID
371: , ISU_ID
372: , OBJECT_VERSION_NUMBER
373: FROM OKL_INS_POLICIES_B
374: WHERE lease_application_id = c_lease_app_id
375: AND IPY_TYPE = 'THIRD_PARTY_POLICY'
376: AND TRUNC(nvl(DATE_TO,SYSDATE)) > TRUNC(SYSDATE);
377:

Line 3337: FROM OKL_INS_POLICIES_B IPYB

3333:
3334: --3379317 Modified by smoduga added new parameter p_to_date
3335: CURSOR C_accepted_policy_exist ( p_khr_id NUMBER , p_date DATE,p_to_date DATE) IS
3336: select 'x'
3337: FROM OKL_INS_POLICIES_B IPYB
3338: WHERE IPYB.IPY_TYPE = 'LEASE_POLICY'
3339: AND IPYB.ISS_CODE IN ('ACCEPTED', 'PENDING')
3340: AND IPYB.KHR_ID = p_khr_id
3341: AND (p_date BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO

Line 3348: FROM OKL_INS_POLICIES_B OIPB

3344: l_dummy VARCHAR2(1);
3345: --3379317 Modified by smoduga added new parameter p_to_date
3346: CURSOR C_policy_exist ( p_khr_id NUMBER , p_date DATE,p_to_date DATE) IS
3347: SELECT 'x'
3348: FROM OKL_INS_POLICIES_B OIPB
3349: WHERE OIPB.KHR_ID = p_khr_id AND
3350: OIPB.IPY_TYPE = 'LEASE_POLICY' AND
3351: OIPB.QUOTE_YN = 'N' AND
3352: OIPB.ISS_CODE = 'ACTIVE' AND

Line 5693: FROM OKL_INS_POLICIES_B

5689:
5690: --Declaring cursor to get policy/quote premium,frequny info.
5691: CURSOR c_pol_qte_dtl(c_id NUMBER) IS
5692: SELECT premium,ipf_code,date_from,date_to,khr_id
5693: FROM OKL_INS_POLICIES_B
5694: WHERE ID = c_id;
5695:
5696: --Get contract currency
5697: CURSOR c_contract_currency_csr(p_khr_id IN NUMBER) IS

Line 6075: ,OKL_INS_POLICIES_B IPY

6071: SELECT IPY.ID
6072: ,IPY.POLICY_NUMBER
6073: ,OKHB.CONTRACT_NUMBER
6074: FROM OKC_K_HEADERS_B OKHB
6075: ,OKL_INS_POLICIES_B IPY
6076: ,OKL_TRX_CONTRACTS CTRX
6077: ,OKC_STATUSES_B OSTS
6078: WHERE OKHB.ID = IPY.KHR_ID
6079: AND OKHB.ID = CTRX.KHR_ID

Line 6095: ,OKL_INS_POLICIES_B IPY

6091: SELECT IPY.ID
6092: ,IPY.POLICY_NUMBER
6093: ,OKHB.CONTRACT_NUMBER
6094: FROM OKC_K_HEADERS_B OKHB
6095: ,OKL_INS_POLICIES_B IPY
6096: ,OKL_IN_RAMOUNT_BC_V KLRA -- Bug 5897792
6097: WHERE KLRA.KLE_ID = IPY.KLE_ID
6098: AND OKHB.ID = IPY.KHR_ID -- smoduga fix for 4383565
6099: AND KLRA.AMOUNT_RECEIVED >= (IPY.PREMIUM * l_percentage_criteria);

Line 7761: from OKL_INS_POLICIES_B

7757: and chr.id = oklchr.id);
7758:
7759: Cursor get_contract_id(p_quote_id NUMBER) is
7760: Select khr_id --Bug:3825159
7761: from OKL_INS_POLICIES_B
7762: where id = p_quote_id;
7763:
7764: Cursor get_product_id(p_contract_id NUMBER) is
7765: Select pdt_id