APPS.FEM_SIGNAGE_PKG SQL Statements

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

Line: 73

   SELECT distinct ext_account_type_code,dim_attribute_varchar_member
   FROM fem_ext_acct_types_attr
   WHERE attribute_id = v_type_attr
   ORDER BY ext_account_type_code;

Line: 161

SELECT min(aw_snapshot_flag),
       min(attribute_id),
       min(version_id),
       count(*)
INTO   v_aw_flag,
       v_sign_attr,
       v_sign_vers,
       v_count
FROM   fem_dim_attr_versions_b
WHERE  attribute_id =
       (SELECT attribute_id
        FROM fem_dim_attributes_b
        WHERE attribute_varchar_label = 'SIGN'
        AND dimension_id =
           (SELECT A.dimension_id
            FROM fem_dimensions_b A
            WHERE A.dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE'))
AND    default_version_flag='Y';

Line: 208

SELECT min(attribute_id),
       min(version_id),
       count(*)
INTO   v_type_attr,
       v_type_vers,
       v_count
FROM   fem_dim_attr_versions_b
WHERE  attribute_id =
       (SELECT attribute_id
        FROM fem_dim_attributes_b
        WHERE attribute_varchar_label = 'BASIC_ACCOUNT_TYPE_CODE'
        AND dimension_id =
            (SELECT A.dimension_id
             FROM fem_dimensions_b A
             WHERE A.dimension_varchar_label = 'EXTENDED_ACCOUNT_TYPE'))
AND   default_version_flag='Y';

Line: 250

   'DELETE FROM fem_ext_acct_types_attr'||
   ' WHERE attribute_id = :b_sign_attr'||
   ' AND version_id = :b_sign_vers';

Line: 256

  p_module => v_block||'.delete_sql_stmt',
  p_msg_text => v_sql_cmd);

Line: 296

   v_sql_cmd := 'INSERT INTO fem_ext_acct_types_attr'||
                '(attribute_id,version_id,ext_account_type_code'||
                ',number_assign_value,creation_date,created_by'||
                ',last_updated_by,last_update_date'||
                ',object_version_number,aw_snapshot_flag)'||
                ' VALUES '||
                '('||v_sign_attr||','||v_sign_vers||','''||v_mem_code||''''||
                ','||v_sign_val||','''||sysdate||''','||c_user_id||
                ','||c_user_id||','''||sysdate||''''||
                ',1,'''||v_aw_flag||''')';

Line: 309

     p_module => v_block||'.insert_sql_stmt',
     p_msg_text => v_sql_cmd);