DBA Data[Home] [Help]

APPS.OKC_CHR_PVT dependencies on FND_LOOKUPS

Line 2268: FROM FND_LOOKUPS

2264:
2265: l_dummy_var VARCHAR2(1) := '?';
2266: CURSOR l_fndv_csr IS
2267: SELECT 'x'
2268: FROM FND_LOOKUPS
2269: WHERE lookup_code = p_chrv_rec.approval_type
2270: AND (lookup_type = 'OKS_REN_ONLINE_APPROVAL'
2271: OR lookup_type = 'OKS_REN_MANUAL_APPROVAL')
2272: AND SYSDATE BETWEEN nvl(start_date_active, SYSDATE)

Line 2305: p_token3_value => 'FND_LOOKUPS');

2301: p_token1_value => 'approval_type',
2302: p_token2 => g_child_table_token,
2303: p_token2_value => G_VIEW,
2304: p_token3 => g_parent_table_token,
2305: p_token3_value => 'FND_LOOKUPS');
2306: -- notify caller of an error
2307: x_return_status := OKC_API.G_RET_STS_ERROR;
2308: END IF;
2309: IF (l_debug = 'Y') THEN