APPS.PAY_ES_BAL_UPLOAD SQL Statements

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

Line: 31

	      SELECT rule_mode
	      FROM   pay_legislation_rules
	      WHERE  legislation_code   ='ES'
	      AND    rule_type          = 'L';

Line: 55

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

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

	   SELECT nvl(ppf.effective_start_date, end_of_time)
	   FROM   per_all_assignments_f ass
		     ,pay_all_payrolls_f ppf
	   WHERE  ass.assignment_id = p_assignment_id
	   AND    p_upload_date BETWEEN
			     nvl(ass.effective_start_date,p_upload_date) AND
			     nvl(ass.effective_end_date,p_upload_date)
	   AND  ppf.payroll_id      = ass.payroll_id
	   AND  p_upload_date BETWEEN
			     nvl(ppf.effective_start_date,p_upload_date) AND
			     nvl(ppf.effective_end_date,p_upload_date);

Line: 110

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

         SELECT  business_group_id
         INTO    l_business_group_id
         FROM    per_assignments_f
         WHERE   assignment_id = p_assignment_id;

Line: 239

	  SELECT tba.source_text,tba.source_text2,tba.balance_type_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;

Line: 251

       SELECT source_text    ,source_text2
       INTO   l_source_text1 ,l_source_text2
       FROM   pay_balance_batch_lines
       WHERE  batch_line_id = p_batch_line_id;

Line: 296

	      SELECT scl.segment2                 work_center
	      FROM   per_all_assignments_f        paaf
		        ,hr_soft_coding_keyflex       scl
	      WHERE  paaf.assignment_id           = p_assignment_id
	      AND    paaf.soft_coding_keyflex_id  = scl.soft_coding_keyflex_id
	      AND    p_effective_date             BETWEEN effective_start_date
						                      AND     effective_end_date;

Line: 305

	      SELECT hoi.organization_id          le_id
	      FROM   hr_organization_information  hoi
	      WHERE  hoi.org_information1         = p_wc_organization_id
	      AND    hoi.org_information_context  = 'ES_WORK_CENTER_REF';