DBA Data[Home] [Help]

APPS.JAI_PA_SETUP_DEF_PKG SQL Statements

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

Line: 10

select count(setup_value_id)
from jai_pa_setup_values
where org_id is not null;
Line: 21

   fnd_file.put_line(fnd_file.log, 'Cannot update. Exiting...');
Line: 24

   update jai_pa_setup_values
   set org_id = p_org_id
   where org_id is null;
Line: 27

   fnd_file.put_line(fnd_file.log, 'Updated existing records with org_id...');