APPS.PAY_KR_BAL_UPLOAD SQL Statements

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

Line: 25

     select nvl(greatest(min(ASS.effective_start_date), p_expiry_date),
                g_eot)
       from per_assignments_f ASS
      where ASS.assignment_id = p_assignment_id
        and ASS.effective_start_date <= p_upload_date
        and ASS.effective_end_date >= p_expiry_date
        and ASS.payroll_id is not null;

Line: 35

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

Line: 47

  select nvl(min(pa.effective_start_date),g_eot)
  from   per_assignments_f pa
  where  pa.assignment_id = p_assignment_id
  and    pa.effective_start_date <= p_upload_date
  and  exists (
          select null
          from   per_time_periods PTP
          where  PTP.payroll_id = pa.payroll_id
            and  pa.effective_start_date between
                 PTP.start_date and PTP.end_date);

Line: 60

  select nvl(add_months(fnd_date.canonical_to_date(org_information11),
     (floor(floor(months_between(p_upload_date,
                                  fnd_date.canonical_to_date(org_information11)))/12)*12)),
	g_eot)
  from   hr_organization_information hoi,
         per_assignments_f           pa
  where  pa.assignment_id = p_assignment_id
  and    p_upload_date
         between pa.effective_start_date and pa.effective_end_date
  and    hoi.organization_id = pa.business_group_id
  and    hoi.org_information_context = 'Business Group Information';

Line: 75

  select nvl(add_months(p_fytd_date,
     (floor(floor(months_between(p_upload_date,
                                  p_fytd_date))/3)*3)),
        g_eot)
  from sys.dual;

Line: 83

  select nvl(add_months(ppos.date_start,
     (floor(floor(months_between(p_upload_date,
                                  ppos.date_start))/12)*12)),
        g_eot)
  from   per_periods_of_service ppos,
         per_assignments_f      pa
  where  pa.assignment_id = p_assignment_id
  and    p_upload_date
         between pa.effective_start_date and pa.effective_end_date
  and    ppos.period_of_service_id = pa.period_of_service_id;

Line: 106

        SELECT  MIN(ptp.regular_payment_date)
        FROM    per_time_periods ptp, per_assignments_f paf
        WHERE   paf.assignment_id = l_assignment_id
        AND     l_upload_date   BETWEEN paf.effective_start_date
                                AND     paf.effective_end_date
        AND     ptp.payroll_id = paf.payroll_id
        AND     ptp.regular_payment_date        BETWEEN l_expiry_date
                                                AND     l_upload_date;

Line: 263

  select pbbl.tax_unit_id,
         pbbl.run_type_id,
         pbbl.source_text
  from
         pay_balance_batch_lines     pbbl
  where  pbbl.batch_line_id = p_batch_line_id;

Line: 273

  select tax_unit_id,
         original_entry_id,
         run_type_id,
         source_text
  from   pay_temp_balance_adjustments
  where  batch_line_id = p_test_batch_line_id;

Line: 288

  select pbt.balance_type_id
  from   pay_balance_types pbt
  where  pbt.balance_type_id = p_balance_type_id
  and    nvl(p_run_type_id, nvl(p_bal_adj_run_type_id,-1))
         = nvl(p_bal_adj_run_type_id,-1)
  and    nvl(p_source_text, nvl(p_bal_adj_source_text,'XX'))
         = nvl(p_bal_adj_source_text,'XX');