DBA Data[Home] [Help]

APPS.PAY_KW_GENERAL dependencies on HR_LOOKUPS

Line 6: l_nationality_cd hr_lookups.meaning%type;

2: /* $Header: pykwgenr.pkb 120.2.12010000.2 2008/09/23 12:59:02 bkeshary ship $ */
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_NATIONALITY_NOT_DEFINED
10: -- This function return NOTEXISTS If the value for HR: Local Nationality

Line 85: l_nationality hr_lookups.meaning%type;

81: -- the Business Group Level.
82: ------------------------------------------------------------------------
83: function get_local_nationality return varchar2
84: is
85: l_nationality hr_lookups.meaning%type;
86: begin
87: l_nationality := hr_general.decode_lookup('NATIONALITY',l_nationality_cd);
88: RETURN l_nationality;
89: END get_local_nationality;