APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_ORIG_SYSTEMS_B

Line 217: l_sst_flag HZ_ORIG_SYSTEMS_B.sst_flag%TYPE := 'N';

213: l_status_owner VARCHAR2(255);
214: l_ar_schema_name VARCHAR2(255);
215: l_tmp VARCHAR2(2000);
216:
217: l_sst_flag HZ_ORIG_SYSTEMS_B.sst_flag%TYPE := 'N';
218: l_rels_updated NUMBER := 0;
219:
220: BEGIN
221:

Line 458: from hz_orig_systems_b

454: IF p_original_system <> 'USER_ENTERED'
455: THEN
456: select sst_flag
457: into l_sst_flag
458: from hz_orig_systems_b
459: where orig_system = p_original_system
460: and status='A';
461:
462: IF l_sst_flag='Y'