DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on HR_GENERAL

Line 79: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',l_nationality_cd);

75: function get_local_nationality return varchar2
76: is
77: l_nationality hr_lookups.meaning%type;
78: begin
79: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',l_nationality_cd);
80: RETURN l_nationality;
81: END get_local_nationality;
82:
83: ------------------------------------------------------------------------

Line 113: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',l_nationality_person);

109: AND p_date_earned between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
110:
111: hr_utility.set_location('l_nationality_person: '||l_nationality_person , 10);
112:
113: l_nationality := hr_general.decode_lookup('AE_NATIONALITY',l_nationality_person);
114: hr_utility.set_location('l_nationality: '||l_nationality , 10);
115:
116: RETURN l_nationality;
117: END get_person_nationality;