DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on FND_LOOKUP_VALUES_VL

Line 1650: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;

1646: ,p_message OUT NOCOPY VARCHAR2
1647: )
1648: RETURN VARCHAR2
1649: IS
1650: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1651: l_proc_step NUMBER(38,10):=0;
1652: l_proc_name VARCHAR2(61):=
1653: g_package_name||'get_lookup_code';
1654: BEGIN

Line 6646: FROM fnd_lookup_values_vl

6642: ,c_view_application_id NUMBER
6643: )
6644: IS
6645: SELECT 'X'
6646: FROM fnd_lookup_values_vl
6647: WHERE lookup_type = p_lookup_type
6648: AND lookup_code = p_lookup_code
6649: AND security_group_id = c_security_group_id
6650: AND view_application_id = c_view_application_id