DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on OKL_K_HEADERS

Line 970: OKL_K_HEADERS_FULL_V OKHV

966: TRUNC(OTQV.creation_date), -- rmunjulu EDAT Added
967: OTQV.perdiem_amount, -- rmunjulu LOANS_ENHANCEMENT
968: OTQV.REPO_QUOTE_INDICATOR_YN -- Bug 6674730
969: FROM OKL_TRX_QUOTES_V OTQV,
970: OKL_K_HEADERS_FULL_V OKHV
971: WHERE OTQV.id = p_id
972: AND OTQV.khr_id = OKHV.id;
973:
974:

Line 978: FROM OKL_K_HEADERS_FULL_V K

974:
975: -- Cursor to get the contract number
976: CURSOR get_k_num_csr ( p_khr_id IN NUMBER) IS
977: SELECT contract_number
978: FROM OKL_K_HEADERS_FULL_V K
979: WHERE K.id = p_khr_id;
980:
981:
982: -- RMUNJULU -- 12-DEC-02 Bug # 2484327 Changes for Asset level termination

Line 1041: OKL_K_HEADERS khr

1037: FROM OKL_STRM_TYPE_B sty,
1038: OKL_STREAMS stm,
1039: OKL_STRM_ELEMENTS ste,
1040: OKL_PROD_STRM_TYPES_V psty,
1041: OKL_K_HEADERS khr
1042: WHERE stm.khr_id = chr.id
1043: AND khr.id = stm.khr_id
1044: AND stm.say_code = 'CURR'
1045: AND stm.active_yn = 'Y'