APPS.OKL_INTEREST_CALC_PVT dependencies on OKL_K_HEADERS

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

94:
95: -- cursor to get scs_code
96: CURSOR scs_code_csr IS
97: SELECT scs_code
98: FROM OKL_K_HEADERS_FULL_V
99: WHERE id = p_khr_id;
100:
101:
102: --commented as a part of user defined streams change - kmotepal

Line 614: FROM OKL_K_HEADERS oklh,

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

Line 874: FROM OKL_K_HEADERS oklh,

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

Line 1146: FROM OKL_K_HEADERS oklh,

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