APPS.AR_LATE_CHARGE_PKG dependencies on AR_LOOKUPS

Line 192: IF pg_ar_lookups_desc_rec.EXISTS(l_hash_value) THEN

188: p_lookup_type||'@*?'||p_lookup_code,
189: 1000,
190: 25000);
191:
192: IF pg_ar_lookups_desc_rec.EXISTS(l_hash_value) THEN
193: l_description := pg_ar_lookups_desc_rec(l_hash_value);
194: ELSE
195:
196: SELECT description

Line 193: l_description := pg_ar_lookups_desc_rec(l_hash_value);

189: 1000,
190: 25000);
191:
192: IF pg_ar_lookups_desc_rec.EXISTS(l_hash_value) THEN
193: l_description := pg_ar_lookups_desc_rec(l_hash_value);
194: ELSE
195:
196: SELECT description
197: INTO l_description

Line 198: FROM ar_lookups

194: ELSE
195:
196: SELECT description
197: INTO l_description
198: FROM ar_lookups
199: WHERE lookup_type = p_lookup_type
200: AND lookup_code = p_lookup_code ;
201:
202: pg_ar_lookups_desc_rec(l_hash_value) := l_description;

Line 202: pg_ar_lookups_desc_rec(l_hash_value) := l_description;

198: FROM ar_lookups
199: WHERE lookup_type = p_lookup_type
200: AND lookup_code = p_lookup_code ;
201:
202: pg_ar_lookups_desc_rec(l_hash_value) := l_description;
203:
204: END IF;
205:
206: END IF;