APPS.PQP_GB_PSI_SCH SQL Statements

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

Line: 155

    ELSIF l_prev_event_dtl_rec.update_type       <> g_prev_event_dtl_rec.update_type THEN
      l_flag                                     := 'N';

Line: 288

    SELECT pee.element_entry_id,
      pee.effective_start_date ,
      pee.effective_end_date,
      pel.element_type_id
    FROM pay_element_entries_f pee,
      pay_element_links_f pel
    WHERE pee.assignment_id = p_assignment_id
    AND pee.entry_type      = 'E'
    AND pee.element_link_id = pel.element_link_id
    AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
    AND pel.element_type_id = c_element_type_id
    AND p_effective_date BETWEEN pel.effective_start_date AND pel.effective_end_date
    ORDER BY pee.effective_start_date DESC;

Line: 482

  SELECT instr(p_input_value,'->'),
    LENGTH(p_input_value)
  INTO l_del_position,
    l_length
  FROM dual;

Line: 487

  SELECT decode(trim(SUBSTR(p_input_value,0,l_del_position-1)),'','0',to_number(trim(SUBSTR(p_input_value,0,l_del_position-1)))),
    decode(trim(SUBSTR(p_input_value,l_del_position +3,l_length-1)),'','0',
    to_number(SUBSTR(p_input_value,l_del_position                 +3,l_length-1)))
  INTO l_old_value,
    l_new_value
  FROM dual;

Line: 515

  l_update_type       VARCHAR2(30);

Line: 570

    debug('g_pay_proc_evt_tab(l_curr_evt_index).update_type:'||g_pay_proc_evt_tab(l_curr_evt_index).update_type);

Line: 571

    l_update_type     := g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 583

    debug('update_type       :'||g_pay_proc_evt_tab(l_curr_evt_index).update_type ,20);

Line: 595

    IF l_update_type ='C' THEN
      get_old_and_new_values( l_chg_value ,l_old_value ,l_new_value );

Line: 597

    elsif l_update_type ='U' THEN
      l_old_value      := g_pay_proc_evt_tab(l_curr_evt_index).old_value;

Line: 632

  l_update_type       VARCHAR2(30);

Line: 677

    l_update_type       := g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 689

    debug('update_type       :'||g_pay_proc_evt_tab(l_curr_evt_index).update_type ,20);

Line: 698

    IF l_update_type ='C' THEN
      get_old_and_new_values( l_chg_value ,l_old_value ,l_new_value );

Line: 700

    elsif l_update_type ='U' THEN
      l_old_value      := g_pay_proc_evt_tab(l_curr_evt_index).old_value;

Line: 730

  l_update_type          VARCHAR2(5);

Line: 756

    l_update_type       := g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 760

    debug('update type:'||l_update_type);

Line: 769

     debug('l_update_type:'||l_update_type);

Line: 770

     IF l_update_type = 'C' THEN
       get_old_and_new_values( l_chg_value ,l_old_value ,l_new_value ); -- get the value from pattern matching code

Line: 775

     elsif l_update_type = 'U' THEN
      debug('old_value         :'||g_pay_proc_evt_tab(l_curr_evt_index).old_value ,20);

Line: 881

  l_update_type       VARCHAR2(30);

Line: 889

   l_update_type       := g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 894

   debug('l_update_type         :'||l_update_type ,20);