APPS.PERWSEPY_PKG SQL Statements

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

Line: 375

     select max(change_date)
     from   per_pay_proposals
     where  assignment_id = p_assignment_id
     and    business_group_id + 0 = p_business_group_id
     and    pay_proposal_id<>nvl(p_pay_proposal_id,-1);

Line: 384

    select null
    from   per_pay_proposals
    where  assignment_id        = p_assignment_id
    and    approved = 'N'
    and    pay_proposal_id<>nvl(p_pay_proposal_id,-1);

Line: 459

select null
from   per_all_assignments_f asg1
where  assignment_id    = p_assignment_id
and    exists (select null
       from   per_all_assignments_f asg2
       where  asg2.assignment_id  = p_assignment_id
       and    asg1.pay_basis_id +0  <> asg2.pay_basis_id
       and    asg2.effective_start_date > p_change_date
       and    asg1.effective_end_date  >= p_change_date);

Line: 533

   select assignment_id,business_group_id,change_date,
	  multiple_components,approved
   from   per_pay_proposals
   where  pay_proposal_id = p_pay_proposal_id
   and    object_version_number = p_object_version_number;

Line: 542

   select max(change_date)
   from   per_pay_proposals
   where  assignment_id = l_assignment_id;

Line: 592

procedure chk_delete_component
   (p_component_id
   in	  per_pay_proposal_components.component_id%TYPE
   ) is
--
  l_exists	varchar2(1);

Line: 598

  l_proc	varchar2(72):= g_package || 'chk_delete_component';

Line: 604

  select null
  from   per_pay_proposals pro
  where  pro.pay_proposal_id = l_pay_proposal_id
  and    pro.approved	     = 'Y';

Line: 612

  select pay_proposal_id
  from   per_pay_proposal_components  comp
  where  comp.component_id = p_component_id;

Line: 648

end chk_delete_component;

Line: 791

  select null
  from per_pay_proposals_v2
  where assignment_id=p_assignment_id
  and approved='N';

Line: 816

  select 1
  from   per_all_assignments_f paf
  where  paf.assignment_id=p_assignment_id
  and    p_date < (select min(paf2.effective_start_date)
                   from   per_all_assignments_f paf2
                   where  paf2.assignment_id=p_assignment_id);

Line: 824

  select 1
  from   per_all_assignments_f paf
  where  paf.assignment_id=p_assignment_id
  and    p_date > (select max(paf2.effective_end_date)
                   from   per_all_assignments_f paf2
                   where  paf2.assignment_id=p_assignment_id);