APPS.HZ_MERGE_DUP_CHECK dependencies on HZ_ORIG_SYSTEMS_B

Line 206: FROM HZ_ORIG_SYSTEMS_B WHERE orig_system = l_cont_source;

202: IF l_cont_source = 'DNB' THEN
203: RETURN FND_API.G_FALSE;
204: ELSE---Find Whether Purchased or Spoke
205: SELECT orig_system_type INTO l_cont_source_type
206: FROM HZ_ORIG_SYSTEMS_B WHERE orig_system = l_cont_source;
207: IF l_cont_source_type = 'PURCHASED' THEN
208: l_source_type :='P';
209: END IF;
210: END IF;

Line 384: FROM HZ_ORIG_SYSTEMS_B WHERE orig_system = l_cont_source;

380: IF l_cont_source = 'DNB' THEN
381: RETURN FND_API.G_FALSE;
382: ELSE---Find Whether Purchased or Spoke
383: SELECT orig_system_type INTO l_cont_source_type
384: FROM HZ_ORIG_SYSTEMS_B WHERE orig_system = l_cont_source;
385: IF l_cont_source_type = 'PURCHASED' THEN
386: l_source_type :='P';
387: END IF;
388: END IF;

Line 550: FROM HZ_ORIG_SYSTEMS_B WHERE orig_system = l_cont_source;

546: RETURN FND_API.G_TRUE;
547:
548: ELSE---Find Whether Purchased or Spoke
549: SELECT orig_system_type INTO l_cont_source_type
550: FROM HZ_ORIG_SYSTEMS_B WHERE orig_system = l_cont_source;
551: IF l_cont_source_type = 'PURCHASED' THEN
552: l_source_type :='P';
553: END IF;
554: END IF;