APPS.PAY_USER_TABLE_DATA_PUMP SQL Statements

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

Line: 39

  select object_version_number
    into l_user_table_ovn
    from pay_user_tables
   where user_table_id = l_user_table_id;

Line: 71

  select object_version_number
    into l_user_column_ovn
    from pay_user_columns
   where user_column_id = l_user_column_id;

Line: 118

 select distinct formula_id
   into l_formula_id
   from ff_formulas_f f1,
        ff_formula_types f2
  where f1.formula_type_id = f2.formula_type_id
    and f2.formula_type_name = 'User Table Validation'
    and (business_group_id + 0 = p_business_group_id
        or (business_group_id is null
            and legislation_code =
                hr_api.return_legislation_code(p_business_group_id))
        or (business_group_id is null
	    and legislation_code is null)
	)
    and  upper(formula_name) = upper(p_formula_Name);

Line: 181

  select object_version_number
    into l_user_row_ovn
    from pay_user_rows_f
   where user_row_id = l_user_row_id
     and p_effective_date between effective_start_date
     and effective_end_date;

Line: 220

  select user_column_instance_id
    into l_user_column_instance_id
    from pay_user_column_instances_f
   where user_row_id = l_user_row_id
     and user_column_id = l_user_column_id
     and p_effective_date between effective_start_date
     and effective_end_date
     and (business_group_id + 0 = p_business_group_id
         or (business_group_id is null
            and legislation_code =
                hr_api.return_legislation_code(p_business_group_id))
         or (business_group_id is null
	    and legislation_code is null)
	 );

Line: 270

  select object_version_number
    into l_user_column_instance_ovn
    from pay_user_column_instances_f
   where user_column_instance_id = l_user_column_instance_id
     and p_effective_date between effective_start_date
     and effective_end_date;