APPS.JTF_CAL_UTILITY_PVT SQL Statements

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

Line: 14

    )IS SELECT jrb.user_name
        FROM jtf_rs_resource_extns jrb
        WHERE jrb.resource_id = b_resource_id;

Line: 62

    IS SELECT jrt.group_name resource_name
       FROM jtf_rs_groups_tl   jrt
       WHERE jrt.group_id = b_resource_id
       AND   jrt.language = userenv('LANG');

Line: 68

    IS SELECT jrt.resource_name
       FROM jtf_rs_resource_extns_tl   jrt
       WHERE jrt.resource_id = b_resource_id
       AND   jrt.language = userenv('LANG');

Line: 152

   )IS SELECT jrb.resource_id     ResourceID
       ,      'RS_'||jrb.category ResourceType
       FROM jtf_rs_resource_extns    jrb
       WHERE jrb.user_id = b_UserID;

Line: 187

   IS SELECT jrb.resource_id   ResourceID
      ,      jrt.resource_name ResourceName
      FROM jtf_rs_resource_extns    jrb
      ,    jtf_rs_resource_extns_tl jrt
      WHERE jrb.resource_id = jrt.resource_id
      AND   jrt.language = userenv('LANG')
      AND   jrb.user_id = to_number(fnd_profile.value('USER_ID'));

Line: 229

   ) IS SELECT jrb.resource_id   ResourceID
      ,      'RS_'||jrb.category ResourceType
      ,      jrt.resource_name ResourceName
      FROM jtf_rs_resource_extns    jrb
      ,    jtf_rs_resource_extns_tl jrt
      WHERE jrb.resource_id = jrt.resource_id
      AND   jrt.language = userenv('LANG')
      AND   jrb.user_id = b_UserID;

Line: 438

    IS SELECT jtl.Name
       FROM jtf_task_statuses_tl jtl
       WHERE jtl.task_status_id = b_task_status_id
       AND   jtl.language = userenv('LANG');

Line: 483

    IS SELECT  SUBSTR(fff.web_html_call,1,
               DECODE(INSTR(fff.web_html_call,'?'),0,LENGTH(fff.web_html_call),
               INSTR(fff.web_html_call,'?')-1)) agent
       FROM fnd_form_functions fff, jtf_objects_b jtb
       WHERE jtb.object_code = b_task_source_code
       AND   fff.fUNCTION_ID = jtb.web_function_id;

Line: 491

    IS SELECT  jtb.URL agent
       FROM jtf_objects_b jtb
       WHERE jtb.object_code = b_task_source_code;

Line: 543

    IS SELECT perz_data_desc name
       FROM jtf_perz_data
       WHERE perz_data_id = b_category_id;

Line: 587

    IS SELECT name
       FROM jtf_task_priorities_tl
       WHERE task_priority_id = b_task_priority_id
       AND   language = userenv('LANG');

Line: 632

    IS SELECT jtf_note_id
       FROM jtf_notes_b
       WHERE source_object_code = 'TASK'
       AND   source_object_id = b_task_id
       AND   ROWNUM = 1;

Line: 682

     )IS SELECT  jpa.attribute_value color
         FROM   jtf_perz_profile      jpp
         ,      jtf_perz_data         jpd
         ,      jtf_perz_data_attrib  jpa
         WHERE  jpp.profile_name   =  to_char(b_ResourceID)||':JTF_CAL'
         AND    jpp.profile_id     =  jpd.profile_id
         AND    jpa.perz_data_id   =  jpd.perz_data_id
         AND    jpa.attribute_name =  to_char(b_GroupID)||':COLOR';

Line: 738

     )IS SELECT  flu.meaning color
         FROM   jtf_perz_profile      jpp
         ,      jtf_perz_data         jpd
         ,      jtf_perz_data_attrib  jpa
         ,      fnd_lookups           flu
         WHERE  jpp.profile_name   =  to_char(b_ResourceID)||':JTF_CAL'
         AND    jpp.profile_id     =  jpd.profile_id
         AND    jpa.perz_data_id   =  jpd.perz_data_id
         AND    jpa.attribute_name =  to_char(b_GroupID)||':COLOR'
         AND    flu.lookup_type    =  'JTF_CALND_GROUP_COLOR'
         AND    flu.lookup_code    =  jpa.attribute_value;

Line: 798

     )IS SELECT  jpa.attribute_value color
         FROM   jtf_perz_profile      jpp
         ,      jtf_perz_data         jpd
         ,      jtf_perz_data_attrib  jpa
         WHERE  jpp.profile_name   =  to_char(b_ResourceID)||':JTF_CAL'
         AND    jpp.profile_id     =  jpd.profile_id
         AND    jpa.perz_data_id   =  jpd.perz_data_id
         AND    jpa.attribute_name =  to_char(b_GroupID)||':PREFIX';

Line: 904

  )IS SELECT jpa.attribute_name   AttributeName
      ,      jpa.attribute_value  AttributeValue
      FROM jtf_perz_profile         jpp
      ,    jtf_perz_data            jpd
      ,    jtf_perz_data_attrib     jpa
      WHERE jpp.profile_name   = to_char(b_ResourceID)||':JTF_CAL'
      AND   jpp.profile_id     = jpd.profile_id
      AND   jpd.perz_data_id   = jpa.perz_data_id
      AND   jpa.attribute_name IN ( 'APPT_INCR'
                                  , 'ISSUE_INVITATION'
                                  , 'DISPLAY_ITEMS'
                                  , 'CLOCK_FORMAT'
                                  , 'APPT_PREFIX'
                                  , 'APPT_COLOR'
                                  , 'TASK_PREFIX'
                                  , 'TASK_COLOR'
                                  , 'ITEM_PREFIX'
                                  , 'ITEM_COLOR'
                                  , 'WEEK_BEGIN'
                                  , 'WEEK_END'
                                  , 'SUNDAY_START'
                                  , 'SUNDAY_END'
                                  , 'MONDAY_START'
                                  , 'MONDAY_END'
                                  , 'TUESDAY_START'
                                  , 'TUESDAY_END'
                                  , 'WEDNESDAY_START'
                                  , 'WEDNESDAY_END'
                                  , 'THURSDAY_START'
                                  , 'THURSDAY_END'
                                  , 'FRIDAY_START'
                                  , 'FRIDAY_END'
                                  , 'SATURDAY_START'
                                  , 'SATURDAY_END'
                                  , 'TASK_CUST_SRC' );

Line: 1408

  )IS SELECT jrb.user_id
      FROM jtf_rs_resource_extns jrb
      WHERE jrb.resource_id = b_resource_id;

Line: 1452

  SELECT 1
   FROM hz_timezones
  WHERE timezone_id = p_timezone_id
  AND ROWNUM = 1;

Line: 1475

  SELECT 1
   FROM jtf_objects_b
  WHERE object_code = p_object_code
  AND ROWNUM = 1;