APPS.PAY_PST_UTILS SQL Statements

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

Line: 13

  g_can_update             VARCHAR2(30)    := 'CAN_UPDATE_UNKNOWN';

Line: 34

      SELECT SUM(DECODE(bl.line_status,'U',1,0)),
             SUM(DECODE(bl.line_status,'V',1,0)),
             SUM(DECODE(bl.line_status,'E',1,0)),
             SUM(DECODE(bl.line_status,'C',1,0))
      FROM   hr_pump_batch_lines bl
      WHERE  bl.batch_id = cp_batch_id;

Line: 42

      SELECT be.exception_text
      FROM   hr_pump_batch_exceptions be
      WHERE  be.source_type = 'BATCH_HEADER'
      AND    be.source_id = cp_batch_id
      AND    be.exception_sequence = (
               SELECT MAX(bx.exception_sequence)
               FROM   hr_pump_batch_exceptions bx
               WHERE  bx.source_type = 'BATCH_HEADER'
               AND    bx.source_id = cp_batch_id
             );

Line: 54

      SELECT cr.actual_start_date,
             nvl(pg.action_parameter_group_name,hr_general.decode_lookup('NAME_TRANSLATIONS','DEFAULT')),
             yn.meaning,
             cr.actual_completion_date,
             cr.completion_text,
             fl.meaning,
             cr.phase_code,
             cr.request_date
      FROM   fnd_concurrent_requests cr,
             fnd_concurrent_programs cp,
             fnd_application fa,
             (select action_parameter_group_name,to_char(action_parameter_group_id) action_parameter_group_id from pay_action_parameter_groups) pg,
             fnd_lookups fl,
             fnd_lookups yn
      WHERE  fa.application_short_name = 'PER'
      AND    cp.application_id = fa.application_id
      AND    cp.concurrent_program_name = 'DATAPUMP'
      AND    cr.program_application_id = cp.application_id
      AND    cr.concurrent_program_id = cp.concurrent_program_id
      AND    cr.argument1 = to_char(cp_batch_id)
      AND    pg.action_parameter_group_id (+)= cr.argument3
      AND    fl.lookup_type = 'CP_PHASE_CODE'
      AND    fl.enabled_flag = 'Y'
      AND    fl.lookup_code = cr.phase_code
      AND    yn.lookup_type = 'YES_NO'
      AND    yn.enabled_flag = 'Y'
      AND    yn.lookup_code = cr.argument2
      AND    cr.request_id = (
               SELECT MAX(crx.request_id)
               FROM   fnd_concurrent_requests crx,
                      fnd_concurrent_programs cpx,
                      fnd_application fax
               WHERE  fax.application_short_name = 'PER'
               AND    cpx.application_id = fax.application_id
               AND    cpx.concurrent_program_name = 'DATAPUMP'
               AND    crx.program_application_id = cpx.application_id
               AND    crx.concurrent_program_id = cpx.concurrent_program_id
               AND    crx.argument1 = to_char(cp_batch_id)
             );

Line: 189

      SELECT am.module_package||'.'||am.module_name,
             SUM(DECODE(bl.line_status,'U',1,0)),
             SUM(DECODE(bl.line_status,'V',1,0)),
             SUM(DECODE(bl.line_status,'E',1,0)),
             SUM(DECODE(bl.line_status,'C',1,0))
      FROM   hr_pump_batch_lines bl,hr_api_modules am
      WHERE  bl.batch_id = cp_batch_id
      AND    bl.api_module_id = cp_api_id
      AND    am.api_module_id = bl.api_module_id
      GROUP BY
             am.module_package||'.'||am.module_name;

Line: 262

  FUNCTION can_update(p_batch_id IN NUMBER) RETURN VARCHAR2 IS
  BEGIN
    cache_batch_data(p_batch_id);

Line: 265

    RETURN g_can_update;

Line: 266

  END can_update;