APPS.PER_QP_INVOCATIONS SQL Statements

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

Line: 7

  select per_quickpaint_invocations_s.nextval
  from   sys.dual;

Line: 21

procedure pre_insert_checks(p_qp_session_id             NUMBER
                           ,p_invocation_context        NUMBER
                           ,p_invocation_type           VARCHAR2
                           ,p_qp_report_id              NUMBER
                           ,p_qp_invocation_id   IN OUT NOCOPY NUMBER) is
--
cursor c is
  select  'x'
  from    per_quickpaint_invocations
  where   qp_session_id       = p_qp_session_id
  and     invocation_context  = p_invocation_context
  and     invocation_type     = p_invocation_type
  and     qp_report_id        = p_qp_report_id;

Line: 36

  select  per_quickpaint_invocations_s.nextval
  from    sys.dual;

Line: 43

hr_utility.set_location('per_qp_invocations.pre_insert_checks',1);

Line: 69

end pre_insert_checks;

Line: 82

  select assignment_set_name
  from   hr_assignment_sets
  where  assignment_set_id = p_invocation_context;

Line: 87

  select qp_report_name
  from   ff_qp_reports
  where  qp_report_id = p_qp_report_id;

Line: 92

  select p.full_name
  ,      a.assignment_number
  ,      hr_person_type_usage_info.get_user_person_type(p_session_date,p.person_id)
  from   per_people        p
  ,      per_assignments_f a
  where  p.person_id = a.person_id
  and    a.assignment_id = p_invocation_context
  and    p_session_date between a.effective_start_date
                        and     a.effective_end_date;

Line: 189

  select text
  from   per_quickpaint_result_text
  where  assignment_id    = p_assignment_id
  and    qp_invocation_id = p_qp_invocation_id
  order by line_number;

Line: 233

  select full_name
  ,      user_person_type
  ,      assignment_number
  from   per_quickpaint_assignments a
  where  assignment_id = p_assignment_id
  and    exists(select null
                from   per_quickpaint_result_text t
                where  t.assignment_id = p_assignment_id
                and    t.qp_invocation_id = p_qp_invocation_id);

Line: 262

  select  value
  from    pay_restriction_values
  where   restriction_code = l_customization_type
  and     customized_restriction_id = p_customized_restriction_id;

Line: 315

  select a.assignment_id
  from   per_assignments_f a
  ,      per_people        p
  where  a.person_id = p.person_id
  and    ((p_assignment_number is null
  and    a.assignment_number is null)
  or     (p_assignment_number is not null
  and    a.assignment_number = p_assignment_number))
  and    p.full_name = p_full_name
  and    a.business_group_id + 0 = p_business_group_id
  and    p_session_date between a.effective_start_date
                        and     a.effective_end_date;

Line: 350

procedure delete_quickpaints(p_qp_session_id NUMBER) is
--
begin
--
hr_utility.set_location('per_qp_invocations.delete_quickpaints',1);

Line: 356

  delete from per_quickpaint_invocations
  where qp_session_id = p_qp_session_id;

Line: 361

end delete_quickpaints;