APPS.PQH_PTE_BUS SQL Statements

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

Line: 110

    select null
    from   pqh_position_transactions a
    where  a.position_transaction_id = p_position_transaction_id;

Line: 185

    select null
    from   per_position_info_types a
    where  a.information_type = p_information_type;

Line: 233

Procedure insert_validate(p_rec in pqh_pte_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 240

  select *
  from pqh_position_transactions
  where position_transaction_id = p_position_transaction_id;

Line: 325

End insert_validate;

Line: 330

Procedure update_validate(p_rec in pqh_pte_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 388

End update_validate;

Line: 393

Procedure delete_validate(p_rec in pqh_pte_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 403

End delete_validate;