APPS.PAY_NL_BAL_UPLOAD SQL Statements

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

Line: 36

     select rule_mode
      from pay_legislation_rules
      where legislation_code='NL'
      and rule_type = 'L';

Line: 68

   select
      nvl(ptp.start_date, END_OF_TIME)
   from
      per_time_periods ptp, per_assignments_f ass
   where
      ass.assignment_id = p_assignment_id
   and
      ptp.payroll_id = ass.payroll_id
   and
      p_upload_date between ass.effective_start_date and ass.effective_end_date
   and
      p_upload_date between ptp.start_date and ptp.end_date;

Line: 87

   select
      nvl(min(ass.effective_start_date), END_OF_TIME)
   from
      per_assignments_f ass
   where
      ass.assignment_id = p_assignment_id
   and
      ass.payroll_id is not null
   and
      ass.effective_start_date <= p_upload_date;

Line: 133

   select
      nvl(ppf.effective_start_date, END_OF_TIME)
   from
      per_all_assignments_f ass,
      pay_all_payrolls_f ppf
   where
      ass.assignment_id = p_assignment_id
   and p_upload_date between
        nvl(ass.effective_start_date,p_upload_date) and
        nvl(ass.effective_end_date,p_upload_date)
   and ppf.payroll_id = ass.payroll_id
   and p_upload_date between
                    nvl(ppf.effective_start_date,p_upload_date) and
                    nvl(ppf.effective_end_date,p_upload_date);

Line: 157

   select nvl(min(EE.effective_start_date), END_OF_TIME)
   from   pay_element_entries_f EE
   where  EE.assignment_id         = p_assignment_id
   and  (EE.element_entry_id      = p_original_entry_id or
   EE.original_entry_id     = p_original_entry_id)
   and  EE.effective_start_date  <= p_upload_date;

Line: 181

         select
            business_group_id
         into
            l_business_group_id
         from
            per_assignments_f
         where
            assignment_id = p_assignment_id;

Line: 261

         SELECT l_tax_year - to_char(l_tax_year,'D') + 2
                 + (84*(decode(trunc((to_number((to_char(p_upload_date,'IW')))-1)/12),4,3,trunc((to_number((to_char(p_upload_date,'IW')))-1)/12))))
         INTO   l_lqtd_start_date
         FROM dual;

Line: 377

	  SELECT tba.source_text,tba.balance_type_id
	  FROM   pay_temp_balance_adjustments tba,
    		 pay_balance_batch_lines bbl
	  WHERE  tba.batch_line_id = p_test_batch_line_id
	  AND    bbl.batch_line_id = p_batch_line_id;

Line: 390

       select source_text into l_source_text1 from pay_balance_batch_lines where batch_line_id=p_batch_line_id;