APPS.PAY_MX_SOE_SS_PKG SQL Statements

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

Line: 71

    lv_sql := 'select earn_bal_name COL01
             ,nvl(earn_reporting_name, earn_bal_name) COL02
             ,to_char(days_run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
             ,to_char(earn_run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
       from  PAY_MX_EMPLOYEE_EARNINGS_V
       where assignment_action_id :action_clause
       and   earn_run_val <> 0';

Line: 96

    lv_sql := 'select balance_name COL01
             ,nvl(reporting_name, balance_name) COL02
             ,to_char(run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
       from  PAY_MX_EMPLOYEE_TAXES_V
       where assignment_action_id :action_clause
       and   run_val <> 0';

Line: 119

    lv_sql := 'select balance_name COL01
             ,nvl(reporting_name, balance_name) COL02
             ,to_char(run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
       from  PAY_MX_TAX_CALC_DETAILS_V
       where assignment_action_id :action_clause
       and   run_val <> 0';

Line: 138

      select tax_unit_id, payroll_action_id
      from   pay_assignment_actions
      where  assignment_action_id = cp_assignment_action_id;

Line: 143

      select action_type
      from   pay_payroll_actions
      where  payroll_action_id = cp_payroll_action_id;

Line: 253

    lv_sql := 'select earn_bal_name COL01
             ,nvl(earn_reporting_name, earn_bal_name) COL02
             ,to_char(hours_run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
             ,to_char(earn_run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
       from  PAY_MX_HOURLY_EARNINGS_V
       where assignment_action_id :action_clause
       and   earn_run_val <> 0';

Line: 278

    lv_sql := 'select balance_name COL01
             ,nvl(reporting_name, balance_name) COL02
             ,to_char(run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
       from  PAY_MX_TAXABLE_BENEFITS_V
       where assignment_action_id :action_clause
       and   run_val <> 0';

Line: 301

    lv_sql := 'select balance_name COL01
             ,nvl(reporting_name, balance_name) COL02
             ,to_char(run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
       from  PAY_MX_TAX_BALANCES_V
       where assignment_action_id :action_clause
       and   run_val <> 0';

Line: 324

    lv_sql := 'select balance_name COL01
             ,nvl(reporting_name, balance_name) COL02
             ,to_char(run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
       from  PAY_MX_DEDUCTIONS_V
       where assignment_action_id :action_clause
       and   run_val <> 0';

Line: 347

    lv_sql := 'select balance_name COL01
             ,nvl(reporting_name, balance_name) COL02
             ,to_char(run_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
             ,to_char(mtd_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL17
             ,to_char(ytd_val
                     ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL18
       from  PAY_MX_OTHER_BALANCES_V
       where assignment_action_id :action_clause';

Line: 375

  select pa.payroll_id
  --,      to_number(to_char(pa.effective_date,'J')) effective_date
  ,replace(substr(FND_DATE.DATE_TO_CANONICAL(pa.effective_date),1,10),'/','-') jsqldate       --YYYY-MM-DD
  ,'' || pa.effective_date || '' effective_date
  ,      aa.assignment_id
  ,      pa.business_group_id
  ,      aa.tax_unit_id
  ,''''  || bg.currency_code || '''' currency_code
  ,action_type
  ,fc.name currency_name
  from   pay_payroll_actions pa
  ,      pay_assignment_actions aa
  ,      per_business_groups bg
  ,      fnd_currencies_vl fc
  where  aa.assignment_action_id = p_assignment_action_id
  and    aa.payroll_action_id = pa.payroll_action_id
  and    pa.business_group_id = bg.business_group_id
  and    fc.currency_code = bg.currency_code
  and rownum = 1;

Line: 396

  select assignment_action_id
  from pay_assignment_actions
  where level =
    (select max(level)
     from pay_assignment_actions
     connect by source_action_id =  prior assignment_action_id
     start with assignment_action_id = p_assignment_action_id)
  connect by source_action_id =  prior assignment_action_id
  start with assignment_action_id = p_assignment_action_id;

Line: 409

  select locked_action_id,
         action_sequence
  from pay_action_interlocks,
       pay_assignment_actions paa
  where locking_action_id = p_assignment_action_id
  and locked_action_id = assignment_action_id
  and exists ( select 1 from pay_run_types_f prt
                where prt.legislation_code = 'MX'
                and   prt.run_type_id = paa.run_type_id
                and   prt.run_method <> 'C' )
  order by action_sequence desc;

Line: 436

     select action_type
     into l_action_type
     from  pay_payroll_actions pa
          ,pay_assignment_actions aa
     where  aa.assignment_action_id = p_assignment_action_id
     and    aa.payroll_action_id = pa.payroll_action_id;