APPS.PQH_PTX_BUS SQL Statements

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

Line: 110

    select null
    from   hr_all_organization_units a
    where  a.organization_id = p_organization_id;

Line: 186

    select null
    from   per_position_definitions a
    where  a.position_definition_id = p_position_definition_id;

Line: 262

    select null
    from   per_jobs a
    where  a.job_id = p_job_id;

Line: 338

    select null
    from   hr_locations_all a
    where  a.location_id = p_location_id;

Line: 414

    select null
    from   per_shared_types a
    where  a.shared_type_id = p_availability_status_id;

Line: 490

    select null
    from   per_grades a
    where  a.grade_id = p_entry_grade_id;

Line: 1045

  select 'x'
  from pqh_position_transactions
  where position_id = p_position_id
  and position_transaction_id <> p_position_transaction_id
  and transaction_status not in ('TERMINATE', 'APPLIED', 'REJECT');

Line: 1710

select information3
from pqh_ptx_extra_info
where position_transaction_id = p_position_transaction_id
and information_type = 'PER_FAMILY'
and information3 in ('ACADEMIC','FACULTY');

Line: 1936

select 'X'
from pqh_ptx_extra_info
where position_transaction_id = nvl(p_position_transaction_id,-1)
and information_type = 'PER_SEASONAL';

Line: 1971

select 'X'
from pqh_ptx_extra_info
where position_transaction_id = p_position_transaction_id
and information_type = 'PER_OVERLAP';

Line: 2005

Procedure insert_validate(p_rec in pqh_ptx_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 2183

End insert_validate;

Line: 2188

Procedure update_validate(p_rec in pqh_ptx_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 2372

End update_validate;

Line: 2377

Procedure delete_validate(p_rec in pqh_ptx_shd.g_rec_type
                         ,p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 2388

End delete_validate;

Line: 2401

    select a.legislation_code
    from   per_business_groups a,
           pqh_position_transactions b
    where b.position_transaction_id      = p_position_transaction_id
    and   a.business_group_id = b.business_group_id;