APPS.PY_ZA_TX SQL Statements

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

Line: 31

  /* this selects the effective date for the payroll_run*/
    select ppa.effective_date
      into l_effective_date
      from pay_payroll_actions ppa
      where ppa.payroll_action_id = l_id;

Line: 37

  /* Selects to get the relevant id's */
    select user_table_id
      into l_user_table_id
      from pay_user_tables
      where user_table_name = 'ZA_TAX_TABLE';

Line: 43

    select user_column_id
      into l_fixed_column_id
      from pay_user_columns
      where user_table_id = l_user_table_id
      and user_column_name = 'Fixed';

Line: 49

    select user_column_id
      into l_limit_column_id
      from pay_user_columns
      where user_table_id = l_user_table_id
      and user_column_name = 'Limit';

Line: 55

    select user_column_id
      into l_percentage_column_id
      from pay_user_columns
      where user_table_id = l_user_table_id
      and user_column_name = 'Percentage';

Line: 61

    select purf.user_row_id
      into l_bracket_row
      from pay_user_rows_f purf
      where purf.user_table_id = l_user_table_id
      and (l_effective_date >= purf.effective_start_date
      and l_effective_date <= purf.effective_end_date)
      and (p_taxable_amount >= purf.row_low_range_or_name
      and p_taxable_amount <= purf.row_high_range);

Line: 70

  /* Selects to get the actual values */
    select pucif.value
      into l_fixed
      from pay_user_column_instances_f pucif
      where pucif.user_row_id = l_bracket_row
      and (l_effective_date >= pucif.effective_start_date
      and l_effective_date <= pucif.effective_end_date)
      and pucif.user_column_id = l_fixed_column_id;

Line: 79

    select pucif.value
      into l_limit
      from pay_user_column_instances_f pucif
      where pucif.user_row_id = l_bracket_row
      and (l_effective_date >= pucif.effective_start_date
      and l_effective_date <= pucif.effective_end_date)
      and pucif.user_column_id = l_limit_column_id;

Line: 87

    select pucif.value
      into l_percentage
      from pay_user_column_instances_f pucif
      where pucif.user_row_id = l_bracket_row
      and (l_effective_date >= pucif.effective_start_date
      and l_effective_date <= pucif.effective_end_date)
      and pucif.user_column_id = l_percentage_column_id;

Line: 201

        p_exces_itd_upd := l_exces_should_be - p_apf_exces_bal; -- Return the Excess update figure.

Line: 308

        p_exces_itd_upd := l_exces_should_be - p_ara_exces_bal; -- Return the Excess update figure.

Line: 625

    SELECT effective_end_date,
           global_value
    FROM ff_globals_f
    WHERE effective_end_date < p_ty_ed
    AND effective_end_date > p_ty_sd
    AND effective_end_date < p_cur_per_ed
    AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';

Line: 652

    SELECT per.effective_start_date, per.effective_end_date
    FROM per_assignments_f per,
         fnd_sessions fnd
    WHERE per.assignment_id = c_assignment_id
    AND fnd.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
    AND fnd.session_id = USERENV('sessionid');

Line: 731

    SELECT effective_end_date,
           global_value
    FROM ff_globals_f
    WHERE effective_end_date > p_asg_cal_max
    AND effective_end_date < (p_ty_sd - 1)
    AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';

Line: 753

    SELECT per.effective_start_date
    FROM per_assignments_f per,
         fnd_sessions fnd
    WHERE per.assignment_id = c_assignment_id
    AND fnd.effective_date BETWEEN per.effective_start_date AND per.effective_end_date
    AND fnd.session_id = USERENV('sessionid');

Line: 819

    SELECT global_value
    INTO l_value_at_year_st
    FROM ff_globals_f glb
    WHERE l_effec_date > glb.effective_start_date
    AND l_effec_date < glb.effective_end_date
    AND global_name = 'ZA_CAR_ALLOW_TAX_PERC';