APPS.OKL_AUTO_INSURANCE_PVT dependencies on OKC_K_HEADERS_B

Line 47: -- Org Stripped OKC_K_HEADERS_B JOIN for ORG

43: ------------------------------------------------------------
44: -- Extract all streams to be paid
45: ------------------------------------------------------------
46:
47: -- Org Stripped OKC_K_HEADERS_B JOIN for ORG
48: -- cursor select changed to select streams based on purpose and that come from stream generation template
49: -- of the contract, implemented for insurance user defined streams, Bug 3924300
50:
51: CURSOR c_streams_rec_csr(l_from_bill_date DATE,l_to_bill_date DATE ) IS

Line 61: OKC_K_HEADERS_B chr, -- Added for Org,

57: ste.amount amount,
58: chr.contract_number contract_number
59: FROM okl_strm_elements ste,
60: okl_streams stm,
61: OKC_K_HEADERS_B chr, -- Added for Org,
62: okl_k_headers oklchr,
63: OKL_STRM_TMPT_LINES_UV stl
64:
65: WHERE ste.stream_element_date >= NVL (l_from_bill_date, ste.stream_element_date)

Line 96: l_contract_number okc_k_headers_b.contract_number%type ;

92: ------------------------------------------------------------
93: l_trx_type_id NUMBER ;
94: l_from_bill_date DATE ;
95: l_to_bill_date DATE;
96: l_contract_number okc_k_headers_b.contract_number%type ;
97: l_token_val VARCHAR2(80);
98:
99:
100: ------------------------------------------------------------

Line 369: ,OKC_K_HEADERS_B OCHR

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
373: trunc(IPYB.DATE_TO) = trunc(SYSDATE) + ls_remder_num_days

Line 741: ,OKC_K_HEADERS_B OCHR

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
745: IPYB.DATE_PROOF_PROVIDED IS NULL

Line 906: FROM OKC_K_HEADERS_B OKHB

902: ,OKHB.CONTRACT_NUMBER
903: --Bug # 6318957 SSDESHPA Changes Start
904: ,OKHB.ORG_ID
905: --Bug # 6318957 SSDESHPA Changes End
906: FROM OKC_K_HEADERS_B OKHB
907: ,OKL_K_HEADERS OKLH
908: ,OKC_STATUSES_B OKSB
909: WHERE OKSB.STE_CODE = 'ACTIVE' AND
910: OKHB.STS_CODE = OKSB.CODE AND