APPS.JTF_PREFAB_CA_FILTERS_PKG dependencies on JTF_PREFAB_HA_FILTERS

Line 272: cursor c_ha is select nvl(max(HA_FILTER_ID), 0) from jtf_prefab_ha_filters where HA_FILTER_ID < 10000;

268: l_ca_filter_id NUMBER;
269: l_host_app_id NUMBER;
270:
271: cursor c is select nvl(max(CA_FILTER_ID), 0) from jtf_prefab_ca_filters_b where CA_FILTER_ID < 10000;
272: cursor c_ha is select nvl(max(HA_FILTER_ID), 0) from jtf_prefab_ha_filters where HA_FILTER_ID < 10000;
273: l_pseudo_seq NUMBER := NULL;
274: l_pseudo_seq_ha NUMBER := NULL;
275:
276: CURSOR host_apps_cursor IS

Line 356: INSERT INTO jtf_prefab_ha_filters (ha_filter_id,

352:
353: WHILE host_apps_cursor%FOUND LOOP
354: l_pseudo_seq_ha := l_pseudo_seq_ha + 1;
355:
356: INSERT INTO jtf_prefab_ha_filters (ha_filter_id,
357: object_version_number,
358: created_by,
359: creation_date,
360: last_updated_by,