APPS.PAY_ZA_BAL_UPLOAD SQL Statements

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

Line: 41

   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.prd_information1 = ptp.prd_information1;

Line: 65

   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.prd_information1 = ptp.prd_information1
   and
      ptp2.prd_information2 = ptp.prd_information2;

Line: 91

   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.pay_advice_date = ptp.pay_advice_date;

Line: 115

   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.prd_information3 = ptp.prd_information3;

Line: 138

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

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

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

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

         select
            business_group_id
         into
            l_business_group_id
         from
            per_assignments_f
         where
            assignment_id = p_assignment_id;