APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_CA_COMPS_VL

Line 38: FROM jtf_prefab_ca_comps_vl

34: CURSOR sequence_cursor IS
35: SELECT jtf_prefab_host_apps_s.NEXTVAL from dual;
36: CURSOR cache_comps_cursor IS
37: SELECT ca_comp_id
38: FROM jtf_prefab_ca_comps_vl
39: WHERE application_id = p_application_id and cache_generic_flag='f';
40: CURSOR cache_comps_cursor_gen IS
41: SELECT ca_comp_id
42: FROM jtf_prefab_ca_comps_vl

Line 42: FROM jtf_prefab_ca_comps_vl

38: FROM jtf_prefab_ca_comps_vl
39: WHERE application_id = p_application_id and cache_generic_flag='f';
40: CURSOR cache_comps_cursor_gen IS
41: SELECT ca_comp_id
42: FROM jtf_prefab_ca_comps_vl
43: WHERE cache_generic_flag='t';
44: CURSOR cache_filters_cursor IS
45: SELECT ca_filter_id
46: FROM jtf_prefab_ca_filters_vl