APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_K_HEADERS_B

Line 91: from OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR

87: select CHRB.CURRENCY_CODE,
88: KHR.CURRENCY_CONVERSION_TYPE,
89: KHR.CURRENCY_CONVERSION_RATE,
90: KHR.CURRENCY_CONVERSION_DATE
91: from OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR
92: WHERE KHR.ID = CHRB.ID
93: AND CHRB.ID = l_khr_id;
94:
95: CURSOR try_csr IS

Line 125: okc_k_headers_b chr

121: SELECT ct.object1_id1 id
122: from okc_contacts ct,
123: okc_contact_sources csrc,
124: okc_k_party_roles_b pty,
125: okc_k_headers_b chr
126: where ct.cpl_id = pty.id
127: and ct.cro_code = csrc.cro_code
128: and ct.jtot_object1_code = csrc.jtot_object_code
129: and ct.dnz_chr_id = chr.id

Line 163: FROM okc_k_headers_b

159: -- Added by dpsingh for LE Uptake
160: -- cursor to get the contract number
161: CURSOR contract_num_csr (p_ctr_id NUMBER) IS
162: SELECT contract_number
163: FROM okc_k_headers_b
164: WHERE id = p_ctr_id;
165:
166: l_legal_entity_id Number;
167: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 167: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

163: FROM okc_k_headers_b
164: WHERE id = p_ctr_id;
165:
166: l_legal_entity_id Number;
167: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
168:
169: BEGIN
170:
171: OPEN try_csr;

Line 464: OKC_K_HEADERS_B okch

460: -- This cursor will return the Contract ID from the given contract number
461: CURSOR cont_csr(v_contract_number VARCHAR2) IS
462: SELECT okch.ID
463: FROM OKL_K_HEADERS oklh,
464: OKC_K_HEADERS_B okch
465: WHERE oklh.id = okch.id
466: AND okch.contract_number = v_contract_number
467: AND okch.scs_code = 'LEASE';
468:

Line 725: OKC_K_HEADERS_B okch,

721: oklh.id khr_id,
722: oklh.pdt_id pdt_id,
723: okch.start_date start_date
724: FROM OKL_K_HEADERS oklh,
725: OKC_K_HEADERS_B okch,
726: OKC_RULES_B rule
727: WHERE okch.sts_code IN ('ENTERED', 'COMPLETE','PASSED','INCOMPLETE','PENDING_APPROVAL',
728: 'APPROVED')
729: AND oklh.id = okch.id

Line 998: OKC_K_HEADERS_B okch

994: SELECT oklh.DATE_LAST_INTERIM_INTEREST_CAL,
995: oklh.PDT_ID,
996: oklh.ID
997: FROM OKL_K_HEADERS oklh,
998: OKC_K_HEADERS_B okch
999: WHERE oklh.id = okch.id
1000: AND okch.contract_number = p_contract_number
1001: AND okch.scs_code = 'LEASE';
1002:

Line 1049: okc_k_headers_b chr,

1045: kln.CAPITAL_AMOUNT CAPITAL_AMOUNT,
1046: kln.CAPITALIZED_INTEREST CAPITALIZED_INTEREST
1047: FROM okl_k_lines kln,
1048: okc_k_lines_b cln,
1049: okc_k_headers_b chr,
1050: okc_line_styles_b cls
1051: WHERE chr.contract_number = v_contract_number AND
1052: chr.scs_code = 'LEASE' AND
1053: chr.ID = cln.chr_id AND