APPS.CN_POST_COLLECTION_TAE_PUB SQL Statements

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

Line: 8

G_LAST_UPDATE_DATE     DATE 		     := Sysdate;

Line: 9

G_LAST_UPDATED_BY      NUMBER 		:= fnd_global.user_id;

Line: 12

G_LAST_UPDATE_LOGIN    NUMBER		     := fnd_global.login_id;

Line: 163

      select version_name
      into   l_version_name
      from   jty_trans_usg_pgm_sql
      where  source_id = -1001
      and    trans_type_id = -1002
      and    program_name  = 'SALES/INCENTIVE COMPENSATION PROGRAM'
      and    enabled_flag  = 'Y';