APPS.AR_LATE_CHARGE_PKG dependencies on AR_LOOKUPS

Line 195: IF pg_ar_lookups_desc_rec.EXISTS(l_hash_value) THEN

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

Line 196: l_description := pg_ar_lookups_desc_rec(l_hash_value);

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

Line 201: FROM ar_lookups

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

Line 205: pg_ar_lookups_desc_rec(l_hash_value) := l_description;

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