APPS.PAY_CORE_XDO_UTILS SQL Statements

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

Line: 9

   SELECT request_id
     FROM pay_payroll_actions
    WHERE payroll_action_id = c_pact_id;

Line: 15

   SELECT app.application_short_name, fcp.application_id
     FROM fnd_application_vl app,
          fnd_concurrent_programs fcp,
          fnd_concurrent_requests r
    WHERE fcp.concurrent_program_id = r.concurrent_program_id
      AND r.request_id = c_request_id
      and app.application_id = fcp.application_id;

Line: 26

    SELECT template_name --template_type_code
      FROM xdo_templates_vl
     WHERE template_code = c_templ_code;

Line: 31

      SELECT prv.value,
          prd.report_type,
          prd.report_level,
          prd.report_definition_id,
          nvl(prd.application_short_name,'PAY'),
          prv.definition_type,
          prv.report_variable_id
     FROM pay_report_groups              prg,
          pay_payroll_actions            ppa,
          pay_report_definitions         prd,
          pay_report_categories          prc,
          pay_report_category_components prcc,
          pay_report_variables           prv
    WHERE prg.short_name =
               nvl(pay_core_utils.get_parameter('REP_GROUP',
                                                ppa.legislative_parameters),
                   -1)
      AND ppa.payroll_action_id = l_payroll_action_id
      AND prg.report_group_id = prd.report_group_id
      AND prc.short_name =
               nvl(pay_core_utils.get_parameter('REP_CAT',
                                                ppa.legislative_parameters),
                   -1)
      AND prc.report_category_id = prcc.report_category_id
      AND prcc.report_definition_id = prd.report_definition_id
      AND prv.report_variable_id = prcc.style_sheet_variable_id
    ORDER BY prd.report_definition_id;

Line: 60

      SELECT parameter_value
      FROM pay_action_parameters
      where parameter_name = p_param_name;

Line: 97

      select number_of_copies,
        printer,
        print_style,
        save_output_flag
      into  copies_buffer,
        printer_buffer,
        style_buffer,
        save_result
      from  fnd_concurrent_requests
      where request_id = fnd_number.canonical_to_number(req_id);

Line: 235

select file_detail_id
  from pay_file_details
 where source_id = payroll_act_id
    or source_id in (select assignment_action_id
                       from pay_assignment_actions paa
                      where payroll_action_id = payroll_act_id);

Line: 247

                delete from pay_file_details
                where file_detail_id = fdetlst(i);

Line: 256

/* This procedure deletes created actions after the submitted requests gets completed */
PROCEDURE standard_deinit(pactid IN NUMBER) IS
remove_act      VARCHAR2(10);

Line: 271

SELECT parameter_value
  FROM pay_action_parameters
 WHERE parameter_name = p_param_name;

Line: 279

   request_list.delete;

Line: 331

      select pay_core_utils.get_parameter('REMOVE_ACT',
                                          pa1.legislative_parameters)
        into remove_act
        from pay_payroll_actions pa1
       where pa1.payroll_action_id = pactid;

Line: 339

         hr_utility.trace ('pay_file_details deleted');