APPS.CAC_SYNC_COMMON SQL Statements

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

Line: 28

      SELECT jta_sync_contact_mapping_s.nextval
        INTO l_seqnum
        FROM DUAL;

Line: 130

       SELECT user_id
         FROM fnd_user
        WHERE user_name = p_user_name;

Line: 146

       SELECT resource_id
         FROM jtf_rs_resource_extns
        WHERE user_id = p_user_id;

Line: 162

       SELECT timezone_id
         FROM HZ_TIMEZONES
        WHERE global_timezone_name = p_timezone_name;

Line: 201

     )IS SELECT territory_code code
         FROM fnd_territories_tl -- using TL since a match in any language will do
         WHERE UPPER(b_country) = UPPER(territory_short_name)
         OR    UPPER(b_country) = UPPER(description)
         OR    UPPER(b_country) = UPPER(territory_code);