APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_K_HEADERS_B

Line 85: from OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR

81: select CHRB.CURRENCY_CODE,
82: KHR.CURRENCY_CONVERSION_TYPE,
83: KHR.CURRENCY_CONVERSION_RATE,
84: KHR.CURRENCY_CONVERSION_DATE
85: from OKC_K_HEADERS_B CHRB,OKL_K_HEADERS KHR
86: WHERE KHR.ID = CHRB.ID
87: AND CHRB.ID = l_khr_id;
88:
89: CURSOR try_csr IS

Line 119: okc_k_headers_b chr

115: SELECT ct.object1_id1 id
116: from okc_contacts ct,
117: okc_contact_sources csrc,
118: okc_k_party_roles_b pty,
119: okc_k_headers_b chr
120: where ct.cpl_id = pty.id
121: and ct.cro_code = csrc.cro_code
122: and ct.jtot_object1_code = csrc.jtot_object_code
123: and ct.dnz_chr_id = chr.id

Line 157: FROM okc_k_headers_b

153: -- Added by dpsingh for LE Uptake
154: -- cursor to get the contract number
155: CURSOR contract_num_csr (p_ctr_id NUMBER) IS
156: SELECT contract_number
157: FROM okc_k_headers_b
158: WHERE id = p_ctr_id;
159:
160: l_legal_entity_id Number;
161: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 161: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

157: FROM okc_k_headers_b
158: WHERE id = p_ctr_id;
159:
160: l_legal_entity_id Number;
161: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
162:
163: BEGIN
164:
165: OPEN try_csr;

Line 520: FROM OKC_K_HEADERS_B

516: SELECT distinct idx.NAME
517: FROM OKL_K_RATE_PARAMS okl,
518: OKL_INDICES idx
519: WHERE okl.khr_id = (SELECT id
520: FROM OKC_K_HEADERS_B
521: WHERE contract_number =p_contract_number
522: AND scs_code = 'LEASE')
523: AND okl.parameter_type_code = 'ACTUAL'
524: AND okl.effective_to_date IS NULL

Line 615: OKC_K_HEADERS_B okch

611: -- This cursor will return the Contract ID from the given contract number
612: CURSOR cont_csr(v_contract_number VARCHAR2) IS
613: SELECT okch.ID
614: FROM OKL_K_HEADERS oklh,
615: OKC_K_HEADERS_B okch
616: WHERE oklh.id = okch.id
617: AND okch.contract_number = v_contract_number
618: AND okch.scs_code = 'LEASE';
619:

Line 875: OKC_K_HEADERS_B okch,

871: oklh.id khr_id,
872: oklh.pdt_id pdt_id,
873: okch.start_date start_date
874: FROM OKL_K_HEADERS oklh,
875: OKC_K_HEADERS_B okch,
876: OKC_RULES_B rule
877: WHERE okch.sts_code IN ('ENTERED', 'COMPLETE','PASSED','INCOMPLETE','PENDING_APPROVAL',
878: 'APPROVED')
879: AND oklh.id = okch.id

Line 1147: OKC_K_HEADERS_B okch

1143: SELECT oklh.DATE_LAST_INTERIM_INTEREST_CAL,
1144: oklh.PDT_ID,
1145: oklh.ID
1146: FROM OKL_K_HEADERS oklh,
1147: OKC_K_HEADERS_B okch
1148: WHERE oklh.id = okch.id
1149: AND okch.contract_number = p_contract_number
1150: AND okch.scs_code = 'LEASE';
1151:

Line 1197: okc_k_headers_b chr,

1193: kln.CAPITAL_AMOUNT CAPITAL_AMOUNT,
1194: kln.CAPITALIZED_INTEREST CAPITALIZED_INTEREST
1195: FROM okl_k_lines kln,
1196: okc_k_lines_b cln,
1197: okc_k_headers_b chr,
1198: okc_line_styles_b cls
1199: WHERE chr.contract_number = v_contract_number AND
1200: chr.scs_code = 'LEASE' AND
1201: chr.ID = cln.chr_id AND