DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_K_HEADERS

Line 958: OKL_K_HEADERS_FULL_V OKHV

954: TRUNC(OTQV.creation_date), -- rmunjulu EDAT Added
955: OTQV.perdiem_amount, -- rmunjulu LOANS_ENHANCEMENT
956: OTQV.REPO_QUOTE_INDICATOR_YN -- Bug 6674730
957: FROM OKL_TRX_QUOTES_V OTQV,
958: OKL_K_HEADERS_FULL_V OKHV
959: WHERE OTQV.id = p_id
960: AND OTQV.khr_id = OKHV.id;
961:
962:

Line 966: FROM OKL_K_HEADERS_FULL_V K

962:
963: -- Cursor to get the contract number
964: CURSOR get_k_num_csr ( p_khr_id IN NUMBER) IS
965: SELECT contract_number
966: FROM OKL_K_HEADERS_FULL_V K
967: WHERE K.id = p_khr_id;
968:
969:
970: -- RMUNJULU -- 12-DEC-02 Bug # 2484327 Changes for Asset level termination

Line 1029: OKL_K_HEADERS khr

1025: FROM OKL_STRM_TYPE_B sty,
1026: OKL_STREAMS stm,
1027: OKL_STRM_ELEMENTS ste,
1028: OKL_PROD_STRM_TYPES_V psty,
1029: OKL_K_HEADERS khr
1030: WHERE stm.khr_id = chr.id
1031: AND khr.id = stm.khr_id
1032: AND stm.say_code = 'CURR'
1033: AND stm.active_yn = 'Y'