APPS.PAY_KW_BAL_UPLOAD SQL Statements

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

Line: 47

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

Line: 63

     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  p_upload_date       between ASS.effective_start_date
                                    and ASS.effective_end_date
       and  PTP.payroll_id    = ASS.payroll_id
       and  p_upload_date      between PTP.start_date
				   and PTP.end_date;

Line: 80

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

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

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

       select source_text into l_source_text1 from pay_balance_batch_lines where batch_line_id=p_batch_line_id;