APPS.PAY_UK_BAL_UPLOAD SQL Statements

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

Line: 101

     select nvl(max(ASS.effective_start_date), START_OF_TIME)
     from   per_assignments_f ASS
	   ,per_assignments_f ASS2
     where  ASS.assignment_id         = p_assignment_id
       and  ASS.effective_start_date <= p_upload_date
       and  ASS2.assignment_id        = ASS.assignment_id
       and  ASS2.effective_end_date   = (ASS.effective_start_date - 1)
       and  ASS2.payroll_id          <> ASS.payroll_id;

Line: 120

     select nvl(min(PTP.regular_payment_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  PTP.regular_payment_date >= p_stat_yr_start_date;

Line: 136

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

    select nvl(greatest(min(ASS.effective_start_date),
                         min(PTP.start_date)), END_OF_TIME)
       from per_assignments_f ASS
           ,per_time_periods  PTP
      where ASS.assignment_id = p_assignment_id
        and ASS.effective_start_date <= p_upload_date
        and PTP.start_date <= p_upload_date
        and PTP.payroll_id   = ASS.payroll_id;

Line: 174

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

        select nvl(min(p.effective_start_date) ,END_OF_TIME)
                   from per_people_f p,
                        per_assignments_f ASS
                   where p.per_information2 = 'Y'
                   and ASS.assignment_id = p_assignment_id
                   and p_upload_date between
                         ASS.effective_start_date and ASS.effective_end_date
                   and ASS.person_id = P.person_id
                   and P.effective_start_date <= p_upload_date
                   and p.effective_end_date >= p_stat_yr_start_date  ;

Line: 259

     SELECT  DISTINCT business_group_id
             INTO l_business_group_id
             FROM per_assignments_f
             WHERE assignment_id = p_assignment_id;