APPS.PAY_PROCESSING_RULE_DATA_PUMP dependencies on HR_LOOKUPS

Line 114: l_lookup hr_lookups.lookup_code%type;

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:

Line 115: l_meaning hr_lookups.meaning%type;

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

Line 116: l_standard_lookup hr_lookups.meaning%type;

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

Line 117: l_balance_lookup hr_lookups.meaning%type;

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

Line 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