APPS.PVX_UTILITY_PVT SQL Statements

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

Line: 44

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

Line: 88

   SELECT 'Y'
   FROM   jtf_rs_role_relations role_reln,  jtf_rs_roles_vl rl
   WHERE  rl.ROLE_TYPE_CODE = 'PRM'
   AND    rl.role_code = 'PV_VENDOR_ADMINISTRATOR'
   AND    rl.role_id = role_reln.role_id
   AND    role_reln.role_resource_type = 'RS_INDIVIDUAL'
   AND    role_reln.ROLE_RESOURCE_ID = p_res_id
   AND    delete_flag = 'N'
   AND    TRUNC(SYSDATE) BETWEEN TRUNC(role_reln.start_date_active)
   AND    TRUNC(NVL(role_reln.end_date_active,SYSDATE));

Line: 129

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || p_lookup_table_name;

Line: 174

   l_sql := 'SELECT 1 FROM DUAL WHERE EXISTS (SELECT 1 FROM ' || UPPER(p_table_name);

Line: 324

      SELECT meaning
      FROM   pv_lookups
      WHERE  lookup_type = UPPER (p_lookup_type)
      AND    lookup_code = UPPER (p_lookup_code);

Line: 366

select NAME
 from  FND_TIMEZONES_VL  --HZ_TIMEZONES_VL
where  UPGRADE_TZ_ID = l_time_id;

Line: 412

select NAME
 from  FND_TIMEZONES_VL   --HZ_TIMEZONES_VL
where  UPGRADE_TZ_ID = l_time_id;

Line: 628

      SELECT meaning
      FROM   pv_lookups
      WHERE  lookup_type = UPPER (p_lookup_type)
      AND    lookup_code = UPPER (p_lookup_code);

Line: 654

      SELECT full_name
      FROM   jtf_rs_res_emp_vl
      WHERE  resource_id = p_resource_id; */

Line: 660

     SELECT full_name
     FROM   jtf_rs_resource_extns rsc,
            per_all_people_f ppl
     WHERE  rsc.category  = 'EMPLOYEE'
     AND    ppl.person_id = rsc.source_id
     AND    resource_id   = p_resource_id;

Line: 695

    select b.cust_account_id
    from hz_party_preferences a, hz_cust_accounts b
    where category = 'PRIMARY_ACCOUNT'
    and a.preference_code = 'CUSTOMER_ACCOUNT_ID'
    and a.party_id = cv_contact_rel_party_id
    and b.cust_account_id=a.value_number and nvl(status,'A')='A';

Line: 703

    select cust_account_id
    from hz_cust_accounts where cust_account_id in
    (select  cust_account_id
     from hz_cust_account_roles
     where party_id = cv_contact_rel_party_id
     and nvl(status,'A')='A'
    )
    and nvl(status,'A')='A'
    order by creation_date asc;

Line: 769

      SELECT PV_GE_HISTORY_LOG_B_S.NEXTVAL
      FROM dual;

Line: 773

   SELECT 'Y'
   FROM fnd_new_messages
   WHERE message_name = cv_message_code
     AND application_id in (691, 682);

Line: 783

	   SELECT PV_GE_HISTORY_LOG_PARAMS_S.NEXTVAL
	   FROM dual;

Line: 861

  PV_Ge_Hist_Log_PKG.Insert_Row (
          px_entity_history_log_id      => l_entity_history_log_id,
          px_object_version_number      => x_object_version_number,
          p_arc_history_for_entity_code => p_arc_history_for_entity_code ,
          p_history_for_entity_id       => p_history_for_entity_id ,
          p_message_code                => p_message_code,
          p_history_category_code       => p_history_category_code ,
          p_partner_id                  => p_partner_id,
          p_access_level_flag           => p_access_level_flag,
          p_interaction_level           => p_interaction_level,
          p_comments                    => p_comments,
          p_created_by                  => FND_GLOBAL.USER_ID,
          p_creation_date               => SYSDATE,
          p_last_updated_by             => FND_GLOBAL.USER_ID,
          p_last_update_date            => SYSDATE,
          p_last_update_login           => NULL
	  );

Line: 886

    PV_Ge_Hl_Param_PKG.Insert_Row (
          px_history_log_param_id    => l_history_log_param_id,
          p_entity_history_log_id   => l_entity_history_log_id,
          p_param_name               => p_log_params_tbl(i).param_name,
          px_object_version_number   => x_object_version_number,
          p_param_value              => p_log_params_tbl(i).param_value,
          p_created_by               => FND_GLOBAL.USER_ID,
          p_creation_date            => SYSDATE,
          p_last_updated_by          => FND_GLOBAL.USER_ID,
          p_last_update_date         => SYSDATE,
          p_last_update_login        => NULL,
          p_param_type               => p_log_params_tbl(i).param_type,
          p_lookup_type              => p_log_params_tbl(i).param_lookup_type
	  );

Line: 954

   select count(*)
      from ( select rownum rnum
               from sys.all_objects
              where rownum <= p_to_date - p_from_date)
     where to_char( p_from_date+rnum, 'DY' ,'nls_date_language=english')
                      not in ( 'SAT', 'SUN' );