APPS.PER_ASN_BUS SQL Statements

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

Line: 24

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

Line: 74

end chk_non_updateable_args;

Line: 123

    select null
    from per_competence_elements
    where p_assessment_id = assessment_id;

Line: 128

    select date_from , date_to
    from per_assessment_types
    where p_assessment_type_id = assessment_type_id
    and   p_business_group_id  = business_group_id;

Line: 315

    select distinct(min(effective_start_date)), business_group_id
    from per_all_people_f per
    where per.person_id = p_person_id
    group by business_group_id;

Line: 415

    select distinct(min(effective_start_date)), business_group_id
    from per_all_people_f per
    where per.person_id = p_assessor_person_id
    group by business_group_id;

Line: 601

    select distinct(min(effective_start_date)), business_group_id
    from per_all_people_f per
    where per.person_id = p_group_initiator_id
    group by business_group_id;

Line: 886

    select null
    from per_assessments
    where  assessment_type_id   = p_assessment_type_id
      and  assessment_date      = p_assessment_date
      and  person_id  	        = p_person_id
      and  assessor_person_id   = p_assessor_person_id
      and  group_date     	= group_date
      and (assessment_id	<> p_assessment_id
	   OR p_assessment_id  is NULL);

Line: 972

    select null
    from per_assessment_groups
    where assessment_group_id = p_assessment_group_id
    and   business_group_id   = p_business_group_Id;

Line: 1058

    select null
    from per_appraisals
    where appraisal_id = p_appraisal_id
    and   business_group_id   = p_business_group_id;

Line: 1131

    select null
    from per_competence_elements
    where assessment_id = p_assessment_id;

Line: 1304

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

Line: 1464

End insert_validate;

Line: 1469

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

Line: 1495

  per_asn_bus.chk_non_updateable_args
    (p_rec      =>  p_rec);

Line: 1579

End update_validate;

Line: 1584

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

Line: 1599

End delete_validate;

Line: 1611

          select legislation_code
          from   per_business_groups pbg,
                 per_assessments     pas
          where  pas.assessment_id     = p_assessment_id
            and  pbg.business_group_id = pas.business_group_id;