APPS.HR_COMPETENCES_API dependencies on FND_LOOKUP_VALUES

Line 1711: (p_meaning in fnd_lookup_values.meaning%TYPE default null

1707: --
1708: -- Declare local modules
1709: --
1710: function return_lookup_code
1711: (p_meaning in fnd_lookup_values.meaning%TYPE default null
1712: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
1713: ,p_language_code in fnd_lookup_values.language%TYPE
1714: )
1715: Return fnd_lookup_values.lookup_code%TYPE Is

Line 1712: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE

1708: -- Declare local modules
1709: --
1710: function return_lookup_code
1711: (p_meaning in fnd_lookup_values.meaning%TYPE default null
1712: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
1713: ,p_language_code in fnd_lookup_values.language%TYPE
1714: )
1715: Return fnd_lookup_values.lookup_code%TYPE Is
1716: --

Line 1713: ,p_language_code in fnd_lookup_values.language%TYPE

1709: --
1710: function return_lookup_code
1711: (p_meaning in fnd_lookup_values.meaning%TYPE default null
1712: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
1713: ,p_language_code in fnd_lookup_values.language%TYPE
1714: )
1715: Return fnd_lookup_values.lookup_code%TYPE Is
1716: --
1717: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;

Line 1715: Return fnd_lookup_values.lookup_code%TYPE Is

1711: (p_meaning in fnd_lookup_values.meaning%TYPE default null
1712: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
1713: ,p_language_code in fnd_lookup_values.language%TYPE
1714: )
1715: Return fnd_lookup_values.lookup_code%TYPE Is
1716: --
1717: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;
1718: --
1719: Cursor Sel_Id Is

Line 1717: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;

1713: ,p_language_code in fnd_lookup_values.language%TYPE
1714: )
1715: Return fnd_lookup_values.lookup_code%TYPE Is
1716: --
1717: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;
1718: --
1719: Cursor Sel_Id Is
1720: select flv.lookup_code
1721: from fnd_lookup_values flv

Line 1721: from fnd_lookup_values flv

1717: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;
1718: --
1719: Cursor Sel_Id Is
1720: select flv.lookup_code
1721: from fnd_lookup_values flv
1722: where flv.lookup_type = p_lookup_type
1723: and UPPER(flv.meaning) = UPPER(p_meaning)
1724: and flv.language = p_language_code
1725: and flv.enabled_flag = 'Y';