DBA Data[Home] [Help]

APPS.PAY_AE_GENERAL dependencies on HR_LOOKUPS

Line 6: l_nationality_cd hr_lookups.meaning%type;

2: /* $Header: pyaegenr.pkb 120.6 2005/11/10 03:05:54 abppradh noship $ */
3: g_package varchar2(30);
4: l_organization_id hr_all_organization_units.organization_id%type;
5: l_person_id per_all_people_f.person_id%type;
6: l_nationality_cd hr_lookups.meaning%type;
7: l_nationality_person per_all_people_f.nationality%type;
8: ------------------------------------------------------------------------
9: -- Function LOCAL_NATNATIONALITY_NOT_DEFINED
10: -- This function return NOTEXISTS If the value for HR: Local Nationality

Line 77: l_nationality hr_lookups.meaning%type;

73: -- the Business Group Level.
74: ------------------------------------------------------------------------
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;