DBA Data[Home] [Help]

APPS.PV_GE_HIST_LOG_PVT dependencies on PV_GE_HISTORY_LOG_PARAMS

Line 1384: FROM pv_ge_history_log_params

1380: l_meaning_cursor cur_type;
1381:
1382: CURSOR c_get_rectype IS
1383: SELECT param_type, lookup_type, param_name, param_value
1384: FROM pv_ge_history_log_params
1385: WHERE entity_history_log_id = p_entity_history_log_id;
1386:
1387: BEGIN
1388:

Line 1424: FOR x IN (SELECT n.NOTES FROM jtf_notes_vl n, PV_GE_HISTORY_LOG_PARAMS p

1420: ELSIF (c_token.param_type = 'NOTE') THEN
1421:
1422: l_note_text := null;
1423: -- this is for note to be added to the text of the log
1424: FOR x IN (SELECT n.NOTES FROM jtf_notes_vl n, PV_GE_HISTORY_LOG_PARAMS p
1425: WHERE p.ENTITY_HISTORY_LOG_ID = p_entity_history_log_id
1426: AND n.jtf_note_id = p.param_value
1427: AND p.param_type = 'NOTE')
1428: LOOP