DBA Data[Home] [Help]

APPS.PAY_FI_BAL_UPLOAD SQL Statements

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

Line: 18

   select
     greatest(min(asg.effective_start_date)
             ,min(ptp.start_date))
   from
     per_all_assignments_f asg
    ,per_time_periods  ptp
   where asg.assignment_id = p_assignment_id
   and ptp.payroll_id   = asg.payroll_id
   and ptp.start_date <= asg.effective_end_date;
Line: 82

SELECT  ptp.start_date
FROM	per_all_assignments_f ass
       ,per_time_periods  ptp
WHERE	ass.assignment_id = p_assignment_id
AND 	ass.effective_start_date <= p_upload_date
AND	ass.effective_end_date	 >= p_upload_date
AND 	ptp.payroll_id		  = ass.payroll_id
AND 	p_upload_date BETWEEN ptp.start_date
AND     ptp.end_date;
Line: 133

		SELECT TO_DATE('0104'||TO_CHAR(p_upload_date,'YYYY'),'DD/MM/YYYY')
		INTO l_holiday_year
		FROM DUAL;
Line: 227

	  SELECT tba.source_text ,  tba.tax_unit_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
	 AND    nvl(tba.balance_type_id ,0) = nvl(bbl.balance_type_id ,0)
	  AND    nvl(tba.source_text ,0) = nvl(bbl.source_text ,0)
	  AND    nvl(tba.tax_unit_id,0) = nvl(bbl.tax_unit_id,0)
	  AND  tba.tax_unit_id IS NOT NULL
	  AND  tba.source_text IS NOT NULL;