APPS.FTE_PTRACKING SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 109

    l_query := 'SELECT ' ||p_column || ' FROM ' || p_table;

Line: 292

SELECT page_id, base_url, request_method, name, description FROM FTE_PTRK_PAGES
WHERE STATUS = 'COMPLETED'
AND OWNER_APPLICATION_ID = p_application_id
AND CARRIER_PARTY_ID = p_carrier_id
AND GRANULARITY <= p_granularity
AND BUSINESS_CONCEPTS like ('%'||p_tracking_event||'%')
AND ORGANIZATIONS like ('%'||x_org_id||'%')
ORDER BY ORGANIZATIONS ASC;  -- this forces the most restrictive page record.

Line: 302

SELECT --p.param_id, p.param_name,
  s.token_name
FROM fte_ptrk_params p, fte_ptrk_sources s
WHERE  p.token_id = s.token_id
AND    p.flag = 'Y'
AND    p.page_id = l_page_id;

Line: 538

SELECT t.source_table, t.source_column, t.key_column1, t.key_column2, t.key_column3, t.key_column4, t.key_column5
FROM FTE_PTRK_SOURCES t
WHERE t.owner_application_id = p_application_id
AND t.token_name = p_token_name;

Line: 639

    SELECT p.param_name, p.static_value, t.token_id, t.token_name, t.source_table, t.source_column,
           t.key_column1, t.key_column2, t.key_column3, t.key_column4, t.key_column5
    FROM FTE_PTRK_PARAMS p, FTE_PTRK_SOURCES t
    WHERE p.page_id = p_page_id
    and p.token_id = t.token_id (+);