APPS.PAY_CA_VALUE_VALIDATION SQL Statements

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

Line: 16

SELECT 'S'
from   pay_wci_accounts
where  account_number = p_act_number
and    business_group_id = p_bus_group_id;

Line: 48

SELECT 'S'
from   pay_wci_rates
where  code = p_code
and    business_group_id = p_bus_group_id;

Line: 80

SELECT 'S'
from   pay_ca_pmed_accounts
where  account_number = p_act_number
and    business_group_id = p_bus_group_id;

Line: 112

SELECT 'S'
from pay_user_tables put
where put.user_table_name = p_user_tab_name
and (
      (put.business_group_id = p_bus_group_id
       and put.legislation_code is null
      )
     or
      (put.business_group_id is null
       and put.legislation_code ='CA'
      )
    );

Line: 152

SELECT 'S'
from pay_user_columns puc
where puc.user_column_name = p_user_tab_col
and (
      (puc.business_group_id = p_bus_group_id
       and puc.legislation_code is null
      )
     or
      (puc.business_group_id is null
       and puc.legislation_code ='CA'
      )
    );