110:
111: invalid_status_stnd exception;
112: invalid_status_badjust exception;
113: l_message varchar2(10000);
114: l_lookup hr_lookups.lookup_code%type;
115: l_meaning hr_lookups.meaning%type;
116: l_standard_lookup hr_lookups.meaning%type;
117: l_balance_lookup hr_lookups.meaning%type;
118:
111: invalid_status_stnd exception;
112: invalid_status_badjust exception;
113: l_message varchar2(10000);
114: l_lookup hr_lookups.lookup_code%type;
115: l_meaning hr_lookups.meaning%type;
116: l_standard_lookup hr_lookups.meaning%type;
117: l_balance_lookup hr_lookups.meaning%type;
118:
119: cursor c_lookup_type is
112: invalid_status_badjust exception;
113: l_message varchar2(10000);
114: l_lookup hr_lookups.lookup_code%type;
115: l_meaning hr_lookups.meaning%type;
116: l_standard_lookup hr_lookups.meaning%type;
117: l_balance_lookup hr_lookups.meaning%type;
118:
119: cursor c_lookup_type is
120: Select lookup_code, meaning
113: l_message varchar2(10000);
114: l_lookup hr_lookups.lookup_code%type;
115: l_meaning hr_lookups.meaning%type;
116: l_standard_lookup hr_lookups.meaning%type;
117: l_balance_lookup hr_lookups.meaning%type;
118:
119: cursor c_lookup_type is
120: Select lookup_code, meaning
121: from hr_lookups
117: l_balance_lookup hr_lookups.meaning%type;
118:
119: cursor c_lookup_type is
120: Select lookup_code, meaning
121: from hr_lookups
122: Where lookup_type = 'NAME_TRANSLATIONS'
123: and lookup_code in ('STANDARD','BAL_ADJUST');
124:
125: Begin