APPS.OKL_INTEREST_CALC_PVT dependencies on OKL_K_HEADERS

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 104: FROM OKL_K_HEADERS_FULL_V

100:
101: -- cursor to get scs_code
102: CURSOR scs_code_csr IS
103: SELECT scs_code
104: FROM OKL_K_HEADERS_FULL_V
105: WHERE id = p_khr_id;
106:
107:
108: --commented as a part of user defined streams change - kmotepal

Line 463: FROM OKL_K_HEADERS oklh,

459:
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';

Line 724: FROM OKL_K_HEADERS oklh,

720: oklh.DATE_LAST_INTERIM_INTEREST_CAL last_calc_date,
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')

Line 997: FROM OKL_K_HEADERS oklh,

993: CURSOR cont_head_csr IS
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';