APPS.HZ_LOCATION_SERVICES_PUB dependencies on HZ_LOCATION_PROFILES

Line 688: from HZ_LOCATION_PROFILES

684: where adapter_id = l_adapter_id;
685:
686: CURSOR is_active_profile(l_location_id NUMBER, l_adapter_content_source VARCHAR2) IS
687: select 'X'
688: from HZ_LOCATION_PROFILES
689: where sysdate between effective_start_date and nvl(effective_end_date, sysdate)
690: and actual_content_source = l_adapter_content_source
691: and location_id = l_location_id;
692: