APPS.PQH_SYNCHRONIZE_LOCAL_TCT SQL Statements

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

Line: 10

                select *
                from pqh_txn_category_attributes
                where transaction_category_id = p_transaction_category_id;

Line: 14

                select transaction_category_id,business_group_id
                from pqh_transaction_categories
                where short_name = p_short_name
                and business_group_id is not null;

Line: 39

                  select txn_category_attribute_id,
                         object_version_number
                    into l_lcl_txn_cat_attr_id, l_lcl_txn_cat_attr_ovn
                  from pqh_txn_category_attributes
                  where transaction_category_id = j.transaction_category_id
                  and attribute_id = i.attribute_id;

Line: 50

                  pqh_txn_cat_attributes_api.update_TXN_CAT_ATTRIBUTE(
                         p_validate                       => false
                        ,p_txn_category_attribute_id      => l_lcl_txn_cat_attr_id
                        ,p_value_set_id                   => i.value_set_id
                        ,p_value_style_cd                 => i.value_style_cd
                        ,p_object_version_number          => l_lcl_txn_cat_attr_ovn
                        ,p_effective_date                 => trunc(sysdate)
                       );

Line: 77

                        ,p_select_flag                    => i.select_flag
                        ,p_value_style_cd                 => i.value_style_cd
                        ,p_effective_date                 => trunc(sysdate)
                       );