APPS.PAY_NO_BAL_UPLOAD SQL Statements

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

Line: 41

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

  SELECT   NVL(GREATEST(MIN(ASS.effective_start_date), p_expiry_date),END_OF_TIME)
  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;

Line: 204

	  SELECT tba.source_text ,  tba.tax_unit_id
	  FROM   pay_temp_balance_adjustments tba,
		 pay_balance_batch_lines bbl
	  WHERE  tba.balance_type_id = bbl.balance_type_id
	  AND    tba.batch_line_id = p_test_batch_line_id
	  AND    bbl.batch_line_id = p_batch_line_id
	  AND    nvl(tba.source_text ,0) = nvl(bbl.source_text ,0);