DBA Data[Home] [Help]

APPS.FTE_PTRACKING dependencies on FTE_PTRK_SOURCES

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 539: FROM FTE_PTRK_SOURCES t

535: l_token_value VARCHAR2(100);
536:
537: CURSOR c_token IS
538: SELECT t.source_table, t.source_column, t.key_column1, t.key_column2, t.key_column3, t.key_column4, t.key_column5
539: FROM FTE_PTRK_SOURCES t
540: WHERE t.owner_application_id = p_application_id
541: AND t.token_name = p_token_name;
542:
543:

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;