APPS.PAY_ASSIGNMENT_ACTIONS_PKG SQL Statements

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

Line: 60

 procedure update_row(p_rowid                          in varchar2,
		      p_action_status                  in varchar2 ) is
  begin
  --
   update PAY_ASSIGNMENT_ACTIONS
   set    ACTION_STATUS   = p_action_status
   where  ROWID           = p_rowid;

Line: 68

  end update_row;

Line: 71

  procedure delete_row(p_rowid   in varchar2) is
  --
  begin
  --
    delete from PAY_ASSIGNMENT_ACTIONS
    where  ROWID = p_rowid;

Line: 78

  end delete_row;

Line: 84

    cursor C is select *
                from   PAY_ASSIGNMENT_ACTIONS
                where  rowid = p_rowid
                for update of PAYROLL_ACTION_ID NOWAIT ;

Line: 343

    select aac.assignment_action_id,
	   aac.action_status,
	   pac.action_type
    from   pay_payroll_actions    pac,
	   pay_assignment_actions aac,
	   pay_action_interlocks  loc
    where  loc.locked_action_id  = p_assignment_action_id
    and    loc.locking_action_id = aac.assignment_action_id
    and    aac.pre_payment_id    = p_pre_payment_id
    and    aac.action_status     = 'C'
    and    pac.payroll_action_id = aac.payroll_action_id
    and    pac.action_type  in ('H','E','M','A', 'PP') ;

Line: 360

    select aac.assignment_action_id
    from   pay_payroll_actions    pac,
	   pay_assignment_actions aac,
	   pay_action_interlocks  loc
    where  loc.locked_action_id  = p_assignment_action_id
    and    loc.locking_action_id = aac.assignment_action_id
    and    aac.payroll_action_id = pac.payroll_action_id
    and    pac.action_type       = 'D' ;

Line: 445

    select 'Y'
    into l_exists
    from dual
    where exists (
                   select null
                   from pay_message_lines pml
                   where pml.source_id   = p_assignment_action_id
                   and   pml.source_type = 'A');

Line: 475

     select max(asg.effective_start_date)
       into l_date
       from per_all_assignments_f asg
      where asg.assignment_id = p_assignment_id
        and asg.effective_start_date <= p_effective_date;

Line: 483

      select max(asg.effective_start_date)
        into l_date
        from per_all_assignments_f asg
       where asg.assignment_id = p_assignment_id
         and asg.effective_start_date >= p_effective_date;

Line: 511

     select max(pep.effective_start_date)
       into l_date
       from per_all_people_f pep
      where pep.person_id = p_person_id
        and pep.effective_start_date <= p_effective_date;

Line: 519

      select max(pep.effective_start_date)
        into l_date
        from per_all_people_f pep
       where pep.person_id = p_person_id
         and pep.effective_start_date >= p_effective_date;