APPS.AMS_DM_TARGET_SOURCES_PVT dependencies on AMS_DM_TARGET_SOURCES_S

Line 97: SELECT ams_dm_target_sources_s.NEXTVAL

93: l_org_id NUMBER := FND_API.G_MISS_NUM;
94: l_target_source_rec target_source_rec_type := p_target_source_rec_type_rec;
95: l_dummy NUMBER;
96: CURSOR c_id IS
97: SELECT ams_dm_target_sources_s.NEXTVAL
98: FROM dual;
99:
100: CURSOR c_id_exists (l_id IN NUMBER) IS
101: SELECT 1

Line 544: IS SELECT 1 FROM AMS_DM_TARGETS_B t, AMS_DM_TARGET_SOURCES s

540: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
541: l_object_version_number NUMBER;
542:
543: CURSOR c_target_source (p_target_source_id IN NUMBER)
544: IS SELECT 1 FROM AMS_DM_TARGETS_B t, AMS_DM_TARGET_SOURCES s
545: WHERE s.target_source_id = p_target_source_id
546: AND s.target_id = t.target_id
547: AND s.data_source_id = t.target_source_id;
548: