DBA Data[Home] [Help]

APPS.CAC_NOTE_PURGE_PVT dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 46: from jtf_object_purge_param_tmp

42: select jtf_note_id
43: from jtf_notes_b
44: where source_object_code = p_object_type
45: and source_object_id in ( select object_id
46: from jtf_object_purge_param_tmp
47: where processing_set_id = p_processing_set_id
48: and ( purge_status is null or purge_status <> 'E'));
49:
50: cursor c_fetch_note_contx_ids is

Line 55: from jtf_object_purge_param_tmp

51: select jtf_note_id
52: from jtf_note_contexts
53: where note_context_type = p_object_type
54: and note_context_type_id in ( select object_id
55: from jtf_object_purge_param_tmp
56: where processing_set_id = p_processing_set_id
57: and ( purge_status is null or purge_status <> 'E'));
58:
59: TYPE t_tab_num Is Table Of NUMBER;