DBA Data[Home] [Help]

APPS.OKL_SEC_INVESTOR_PVT dependencies on OKC_K_HEADERS_B

Line 271: FROM okc_k_headers_b

267: (p_chr_id IN VARCHAR2) IS
268: SELECT CURRENCY_CODE,
269: AUTHORING_ORG_ID,
270: END_DATE
271: FROM okc_k_headers_b
272: WHERE id = p_chr_id;
273:
274:
275: l_fetched BOOLEAN := FALSE;

Line 1267: OKC_K_HEADERS_B CHR,OKC_STATUSES_TL STL,OKC_K_HEADERS_TL TL,OKL_K_HEADERS KHR,

1263: POL.POOL_NUMBER,
1264: POL.TOTAL_PRINCIPAL_AMOUNT,
1265: POL.TOTAL_RECEIVABLE_AMOUNT
1266: FROM
1267: OKC_K_HEADERS_B CHR,OKC_STATUSES_TL STL,OKC_K_HEADERS_TL TL,OKL_K_HEADERS KHR,
1268: OKL_PRODUCTS KLP, OKL_POOLS POL, FND_CURRENCIES_VL FND
1269: WHERE
1270: TL.ID = CHR.ID AND STL.CODE = CHR.STS_CODE AND TL.LANGUAGE = USERENV('LANG')
1271: AND KHR.ID = CHR.ID AND KLP.ID(+) = KHR.PDT_ID