APPS.CAC_SYNC_TASK_CATEGORY SQL Statements

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

Line: 42

       SELECT perz_data_id
         FROM JTF_PERZ_DATA
        WHERE perz_data_desc = b_category_name
          AND profile_id = p_profile_id;

Line: 62

       SELECT perz_data_id
         FROM JTF_PERZ_DATA
        WHERE profile_id = b_profile_id;

Line: 78

       SELECT jtf_task_utl.get_category_name(NULL)
         INTO l_unfiled
         FROM DUAL;

Line: 99

             SELECT jtf_task_category_s.nextval
               INTO category_seq
               FROM sys.dual;

Line: 126

     SELECT profile_id
     FROM jtf_perz_profile
     WHERE profile_name = p_resource_id || ':JTF_TASK';