DBA Data[Home] [Help]

APPS.JTY_MISC_UTILS_PKG SQL Statements

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

Line: 83

    SELECT c.denorm_value_table_name,
           c.denorm_dea_value_table_name
    INTO   l_table_name,
           l_dea_table_name
    FROM   jtf_qual_usgs_all a,
           jtf_qual_type_usgs_all b,
           jtf_sources_all c
    WHERE  a.qual_usg_id      = p_qual_usg_id
    AND    a.org_id           = -3113
    AND    a.qual_type_usg_id = b.qual_type_usg_id
    AND    b.source_id        = c.source_id;