APPS.PAY_IE_BAL_UPLOAD SQL Statements

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

Line: 61

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

Line: 95

   select
      nvl(min(ptp2.start_date), END_OF_TIME)
   from
      per_time_periods ptp,per_time_periods ptp2,per_assignments_f ass
   where
      ass.assignment_id = p_assignment_id
   and
      p_upload_date between ass.effective_start_date and ass.effective_end_date
   and
      ptp.payroll_id = ass.payroll_id
   and
      ptp2.payroll_id = ptp.payroll_id
   and
      p_upload_date between ptp.start_date and ptp.end_date
   and
      ptp2.start_date between to_date(l_leg_start||to_char(to_date(p_upload_date,'DD/MM/YYYY'),'YYYY'),'DD/MM/YYYY')
      and ptp.end_date;

Line: 119

   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: 137

   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: 158

   select
      min(ptp.regular_payment_date)
   from
      per_time_periods ptp, per_assignments_f ass
   where
      ass.assignment_id = l_assignment_id
   and
      ptp.payroll_id = ass.payroll_id
   and
      l_upload_date between ass.effective_start_date and ass.effective_end_date
   and
   ptp.regular_payment_date between l_expiry_date and l_upload_date;

Line: 179

   select
      ptp.regular_payment_date
   from
      per_time_periods ptp, per_assignments_f ass
   where
      ass.assignment_id = l_assignment_id
   and
      ptp.payroll_id = ass.payroll_id
   and
      l_upload_date between ass.effective_start_date and ass.effective_end_date
   and
      l_expiry_date between start_date and end_date;

Line: 210

   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: 234

     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: 254

         select
            distinct business_group_id -- for bug 5258159 added distinct clause.
         into
            l_business_group_id
         from
            per_assignments_f
         where
            assignment_id = p_assignment_id;

Line: 414

	  SELECT tba.SOURCE_TEXT
	  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
	  AND    tba.SOURCE_TEXT like nvl(bbl.SOURCE_TEXT,'%');

Line: 426

	  SELECT tba.original_entry_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
	  AND    tba.original_entry_id = bbl.original_entry_id;