APPS.HR_RATING_SCALES_API dependencies on FND_LOOKUP_VALUES

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

656: --
657: -- Declare local modules
658: --
659: function return_lookup_code
660: (p_meaning in fnd_lookup_values.meaning%TYPE default null
661: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
662: ,p_language_code in fnd_lookup_values.language%TYPE
663: )
664: Return fnd_lookup_values.lookup_code%TYPE Is

Line 661: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE

657: -- Declare local modules
658: --
659: function return_lookup_code
660: (p_meaning in fnd_lookup_values.meaning%TYPE default null
661: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
662: ,p_language_code in fnd_lookup_values.language%TYPE
663: )
664: Return fnd_lookup_values.lookup_code%TYPE Is
665: --

Line 662: ,p_language_code in fnd_lookup_values.language%TYPE

658: --
659: function return_lookup_code
660: (p_meaning in fnd_lookup_values.meaning%TYPE default null
661: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
662: ,p_language_code in fnd_lookup_values.language%TYPE
663: )
664: Return fnd_lookup_values.lookup_code%TYPE Is
665: --
666: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;

Line 664: Return fnd_lookup_values.lookup_code%TYPE Is

660: (p_meaning in fnd_lookup_values.meaning%TYPE default null
661: ,p_lookup_type in fnd_lookup_values.lookup_code%TYPE
662: ,p_language_code in fnd_lookup_values.language%TYPE
663: )
664: Return fnd_lookup_values.lookup_code%TYPE Is
665: --
666: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;
667: --
668: Cursor Sel_Id Is

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

662: ,p_language_code in fnd_lookup_values.language%TYPE
663: )
664: Return fnd_lookup_values.lookup_code%TYPE Is
665: --
666: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;
667: --
668: Cursor Sel_Id Is
669: select flv.lookup_code
670: from fnd_lookup_values flv

Line 670: from fnd_lookup_values flv

666: l_lookup_code fnd_lookup_values.lookup_code%TYPE := null;
667: --
668: Cursor Sel_Id Is
669: select flv.lookup_code
670: from fnd_lookup_values flv
671: where flv.lookup_type = p_lookup_type
672: and flv.meaning = p_meaning
673: and flv.language = p_language_code
674: and flv.enabled_flag = 'Y';