APPS.PAY_PROCESSING_RULE_DATA_PUMP dependencies on STANDARD

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 123: and lookup_code in ('STANDARD','BAL_ADJUST');

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
126: --
127: open c_lookup_type;

Line 131: if l_lookup = 'STANDARD' then

127: open c_lookup_type;
128: loop
129: fetch c_lookup_type into l_lookup,l_meaning;
130: exit when c_lookup_type%notfound;
131: if l_lookup = 'STANDARD' then
132: l_standard_lookup := l_meaning;
133: elsif l_lookup = 'BAL_ADJUST' then
134: l_balance_lookup := l_meaning;
135: end if;

Line 132: l_standard_lookup := l_meaning;

128: loop
129: fetch c_lookup_type into l_lookup,l_meaning;
130: exit when c_lookup_type%notfound;
131: if l_lookup = 'STANDARD' then
132: l_standard_lookup := l_meaning;
133: elsif l_lookup = 'BAL_ADJUST' then
134: l_balance_lookup := l_meaning;
135: end if;
136: end loop;

Line 140: if (UPPER(p_assignment_status) = nvl(UPPER(l_standard_lookup),'-1')) then

136: end loop;
137: close c_lookup_type;
138:
139: --
140: if (UPPER(p_assignment_status) = nvl(UPPER(l_standard_lookup),'-1')) then
141: raise invalid_status_stnd;
142: elsif (UPPER(p_assignment_status) = nvl(UPPER(l_balance_lookup),'-1')) then
143: raise invalid_status_badjust;
144: else