APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKL_INS_POLICIES_B

Line 368: FROM OKL_INS_POLICIES_B IPYB

364: SELECT IPYB.KHR_ID
365: ,OCHR.CONTRACT_NUMBER
366: ,IPYB.ID
367: ,OCHR.CUST_ACCT_ID --Bug 4177206
368: FROM OKL_INS_POLICIES_B IPYB
369: ,OKC_K_HEADERS_B OCHR
370: WHERE (IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY' OR
371: (IPYB.IPY_TYPE = 'LEASE_POLICY' AND
372: IPYB.ISS_CODE = 'ACTIVE')) AND

Line 740: FROM OKL_INS_POLICIES_B IPYB

736: CURSOR okl_eli_3rdpolicies_csr(l_no_of_days IN NUMBER ) IS
737: SELECT IPYB.KHR_ID
738: ,OCHR.CONTRACT_NUMBER
739: ,OCHR.CUST_ACCT_ID -- Bug 4177206
740: FROM OKL_INS_POLICIES_B IPYB
741: ,OKC_K_HEADERS_B OCHR
742: WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY' AND
743: IPYB.DATE_PROOF_REQUIRED < SYSDATE AND
744: IPYB.DATE_PROOF_REQUIRED >= SYSDATE - l_no_of_days AND

Line 917: FROM OKL_INS_POLICIES_B IPYB

913: OKLH.ID = OKHB.ID AND
914: (OKHB.START_DATE + l_no_of_days ) <= SYSDATE
915: AND OKHB.ID NOT IN
916: (SELECT IPYB.KHR_ID
917: FROM OKL_INS_POLICIES_B IPYB
918: WHERE IPYB.IPY_TYPE = 'LEASE_POLICY' AND
919: IPYB.QUOTE_YN = 'N' AND
920: IPYB.ISS_CODE = 'ACTIVE' AND
921: (SYSDATE - l_no_of_days ) BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO AND

Line 925: FROM OKL_INS_POLICIES_B IPYB

921: (SYSDATE - l_no_of_days ) BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO AND
922: IPYB.KHR_ID = OKHB.ID
923: UNION
924: SELECT IPYB.KHR_ID
925: FROM OKL_INS_POLICIES_B IPYB
926: WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY' AND
927: (IPYB.DATE_PROOF_PROVIDED IS NOT NULL OR
928: (IPYB.DATE_PROOF_PROVIDED IS NULL AND
929: IPYB.DATE_PROOF_REQUIRED >= SYSDATE)) AND

Line 951: FROM OKL_INS_POLICIES_B IPYB

947:
948: -- Effective From Date
949: CURSOR okl_last_ins_to_csr(l_khr_id IN NUMBER ) IS
950: SELECT IPYB.DATE_TO
951: FROM OKL_INS_POLICIES_B IPYB
952: WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY'
953: AND IPYB.QUOTE_YN = 'N'
954: AND IPYB.DATE_PROOF_PROVIDED IS NOT NULL
955: AND IPYB.KHR_ID = l_khr_id

Line 958: FROM OKL_INS_POLICIES_B IPYB

954: AND IPYB.DATE_PROOF_PROVIDED IS NOT NULL
955: AND IPYB.KHR_ID = l_khr_id
956: UNION
957: SELECT IPYB.DATE_TO
958: FROM OKL_INS_POLICIES_B IPYB
959: WHERE IPYB.IPY_TYPE = 'LEASE_POLICY'
960: AND IPYB.QUOTE_YN = 'N'
961: AND IPYB.ISS_CODE IN ('ACTIVE','EXPIRED','CANCELLED', 'PENDING')
962: AND IPYB.KHR_ID = l_khr_id

Line 1324: FROM OKL_INS_POLICIES_B

1320: EXIT;
1321: END IF;
1322: SELECT IPY_ID
1323: INTO l_policy_id
1324: FROM OKL_INS_POLICIES_B
1325: WHERE ID =x_message ;
1326:
1327: IF (l_policy_id IS NULL) THEN
1328: lb_provider := FALSE ;