APPS.PAY_VOID_UI_PKG SQL Statements

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

Line: 54

  select ppdt.name
  from pay_parameter_definitions_tl ppdt,
       pay_parameters pp,
       pay_parameter_sets pps
  where pps.set_id = p_set_id
    and pps.set_name_id = pp.parameter_def_id
    and pp.parameter_def_id = ppdt.parameter_def_id;

Line: 65

  select ppr_outer.fnd_request_id,
         ppr_outer.process_flow_id,
         rownum
   from pay_process_requests ppr_outer
  where process_request_id =
   (select ppr_inner.process_request_id
      from pay_process_requests ppr_inner
     where ppr_inner.fnd_request_id = p_fnd_request_id
   )
  order by process_req_seq_id;

Line: 79

  select pfs.set_id
    from pay_process_flow_sets pfs
   where pfs.process_flow_id = p_process_flow_id
     and pfs.process_flow_seq = p_process_flow_seq;

Line: 87

  select ppf.set_id
    from pay_process_flows ppf
   where ppf.process_flow_id = p_process_flow_id;

Line: 159

  select initialization_procedure
    from pay_process_flows
   where process_flow_id = p_process_flow_id;