APPS.EGO_IMPORT_BATCHES_PKG dependencies on HZ_ORIG_SYSTEMS_VL

Line 420: FROM HZ_ORIG_SYSTEMS_VL SSM, EGO_SOURCE_SYSTEM_EXT SSM_EXT

416: WHERE MP.ORGANIZATION_ID = v_organization_id;
417:
418: Cursor Ego_Source_System_Csr(v_source_system_code IN VARCHAR2) IS
419: SELECT SSM.ORIG_SYSTEM_ID
420: FROM HZ_ORIG_SYSTEMS_VL SSM, EGO_SOURCE_SYSTEM_EXT SSM_EXT
421: WHERE SSM_EXT.SOURCE_SYSTEM_ID = SSM.ORIG_SYSTEM_ID
422: AND SSM.ORIG_SYSTEM = v_source_system_code;
423:
424: Cursor Ego_Ssm_Options_Csr(v_source_system_id IN NUMBER) IS

Line 556: l_source_system_code HZ_ORIG_SYSTEMS_VL.ORIG_SYSTEM%TYPE := p_source_system_code;

552: l_master_org_rec Ego_Master_Org_Csr%ROWTYPE;
553:
554: l_batch_id NUMBER := NULL; --p_batch_id;
555: l_source_system_id NUMBER := NULL;
556: l_source_system_code HZ_ORIG_SYSTEMS_VL.ORIG_SYSTEM%TYPE := p_source_system_code;
557: l_organization_id NUMBER := p_organization_id;
558: l_master_org_id NUMBER := NULL;
559:
560: l_batch_type_display_name VARCHAR2(30) := p_batch_type_display_name;