APPS.PJI_PJP_FP_CURR_WRAP SQL Statements

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

Line: 123

       SELECT ent_period_id,name,start_date,END_date
       INTO   x_ent_start_period_id, x_ent_start_period_name, x_ent_start_date, x_ent_END_date
       FROM   pji_time_ent_period
       WHERE  x_global_start_date BETWEEN start_date AND END_date;

Line: 180

     SELECT DECODE (planamt_alloc_method
                  , 'PERIOD_START', 'S'
                  , 'PERIOD_END',   'E'
  	  	      , 'DAILY',        'D'
                  , 'X')
     INTO   x_prorating_format
     FROM   pji_system_settings;

Line: 201

     SELECT DECODE ( planamt_conv_date
                   , 'FIRST_DAY', 'S'
    		       , 'LAST_DAY', 'E'
                   , 'X')
     INTO   x_currency_conversion_rule
     FROM   pji_system_settings;

Line: 318

  SELECT NVL(p_own_name, PJI_UTILS.GET_PJI_SCHEMA_NAME)
  INTO   l_own_name
  FROM   DUAL;