APPS.OKL_PFL_PVT dependencies on FND_LOOKUPS

Line 1359: FROM fnd_lookups

1355: item_not_found_error EXCEPTION;
1356: -- PAGARG 16-Aug-2004 3832404: added p_lookup_type parameter
1357: CURSOR okl_pflv_tsuv_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1358: SELECT 'x'
1359: FROM fnd_lookups
1360: WHERE fnd_lookups.lookup_code = p_lookup_code
1361: AND fnd_lookups.lookup_type = p_lookup_type;
1362:
1363: l_okl_pflv_tsuv_fk okl_pflv_tsuv_fk_csr%ROWTYPE;

Line 1360: WHERE fnd_lookups.lookup_code = p_lookup_code

1356: -- PAGARG 16-Aug-2004 3832404: added p_lookup_type parameter
1357: CURSOR okl_pflv_tsuv_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1358: SELECT 'x'
1359: FROM fnd_lookups
1360: WHERE fnd_lookups.lookup_code = p_lookup_code
1361: AND fnd_lookups.lookup_type = p_lookup_type;
1362:
1363: l_okl_pflv_tsuv_fk okl_pflv_tsuv_fk_csr%ROWTYPE;
1364:

Line 1361: AND fnd_lookups.lookup_type = p_lookup_type;

1357: CURSOR okl_pflv_tsuv_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1358: SELECT 'x'
1359: FROM fnd_lookups
1360: WHERE fnd_lookups.lookup_code = p_lookup_code
1361: AND fnd_lookups.lookup_type = p_lookup_type;
1362:
1363: l_okl_pflv_tsuv_fk okl_pflv_tsuv_fk_csr%ROWTYPE;
1364:
1365: -- PAGARG 16-Aug-2004 3832404: added p_lookup_type parameter

Line 1368: FROM fnd_lookups

1364:
1365: -- PAGARG 16-Aug-2004 3832404: added p_lookup_type parameter
1366: CURSOR okl_pflv_atsv_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1367: SELECT 'x'
1368: FROM fnd_lookups
1369: WHERE fnd_lookups.lookup_code = p_lookup_code
1370: AND fnd_lookups.lookup_type = p_lookup_type;
1371: l_okl_pflv_atsv_fk okl_pflv_atsv_fk_csr%ROWTYPE;
1372:

Line 1369: WHERE fnd_lookups.lookup_code = p_lookup_code

1365: -- PAGARG 16-Aug-2004 3832404: added p_lookup_type parameter
1366: CURSOR okl_pflv_atsv_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1367: SELECT 'x'
1368: FROM fnd_lookups
1369: WHERE fnd_lookups.lookup_code = p_lookup_code
1370: AND fnd_lookups.lookup_type = p_lookup_type;
1371: l_okl_pflv_atsv_fk okl_pflv_atsv_fk_csr%ROWTYPE;
1372:
1373: CURSOR okl_pflv_pfcv_fk_csr (p_id IN NUMBER) IS

Line 1370: AND fnd_lookups.lookup_type = p_lookup_type;

1366: CURSOR okl_pflv_atsv_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS
1367: SELECT 'x'
1368: FROM fnd_lookups
1369: WHERE fnd_lookups.lookup_code = p_lookup_code
1370: AND fnd_lookups.lookup_type = p_lookup_type;
1371: l_okl_pflv_atsv_fk okl_pflv_atsv_fk_csr%ROWTYPE;
1372:
1373: CURSOR okl_pflv_pfcv_fk_csr (p_id IN NUMBER) IS
1374: SELECT 'x'