DBA Data[Home] [Help]

APPS.OKS_WF_K_PROCESS_PVT dependencies on FND_LOOKUPS

Line 303: FROM FND_LOOKUPS

299: l_meaning VARCHAR2(250);
300:
301: CURSOR l_lookup_csr IS
302: SELECT meaning
303: FROM FND_LOOKUPS
304: WHERE lookup_code = p_lookup_code
305: AND lookup_type = p_lookup_type;
306:
307: BEGIN

Line 2478: fnd_lookups fndl

2474: CURSOR l_payment_csr(p_chr_id NUMBER) IS
2475: SELECT fndl.meaning
2476: FROM okc_k_headers_all_b okch,
2477: oks_k_headers_b oksh,
2478: fnd_lookups fndl
2479: WHERE okch.id = oksh.chr_id
2480: AND oksh.chr_id = p_chr_id
2481: AND fndl.lookup_code = DECODE(oksh.payment_type, NULL, okch.payment_instruction_type)
2482: AND fndl.lookup_type = G_LKUP_TYPE_PAY_TYPES;