DBA Data[Home] [Help]

APPS.FTE_PTRACKING dependencies on FTE_PTRK_PARAMS

Line 304: FROM fte_ptrk_params p, fte_ptrk_sources s

300:
301: CURSOR get_token(l_page_id NUMBER) IS
302: SELECT --p.param_id, p.param_name,
303: s.token_name
304: FROM fte_ptrk_params p, fte_ptrk_sources s
305: WHERE p.token_id = s.token_id
306: AND p.flag = 'Y'
307: AND p.page_id = l_page_id;
308:

Line 641: FROM FTE_PTRK_PARAMS p, FTE_PTRK_SOURCES t

637:
638: CURSOR c_params(p_page_id IN NUMBER) IS
639: SELECT p.param_name, p.static_value, t.token_id, t.token_name, t.source_table, t.source_column,
640: t.key_column1, t.key_column2, t.key_column3, t.key_column4, t.key_column5
641: FROM FTE_PTRK_PARAMS p, FTE_PTRK_SOURCES t
642: WHERE p.page_id = p_page_id
643: and p.token_id = t.token_id (+);
644:
645: INVALID_INPUT EXCEPTION;