APPS.PAYVWELE SQL Statements

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

Line: 81

SELECT	scl.segment1
INTO	l_tax_unit_id
FROM	hr_soft_coding_keyflex scl,
	per_assignments_f paf
where  scl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
and    paf.assignment_id = p_assignment_id
and    p_session_date between paf.effective_start_date AND paf.effective_end_date;

Line: 111

select balance_dimension_id
into   v_dim_id
from   pay_balance_dimensions
where  database_item_suffix = p_dim_suffix
and legislation_code = p_legislation_code;  /* bug372487 */

Line: 150

   SELECT ppa.effective_date
   INTO   v_action_date
   FROM   pay_payroll_actions ppa,
          pay_assignment_actions paa
   WHERE  paa.assignment_action_id = p_assignment_action_id
   AND    ppa.payroll_action_id = paa.payroll_action_id;

Line: 169

SELECT pps.final_process_date
FROM per_periods_of_service pps
WHERE date_start <= p_session_date
AND pps.period_of_service_id = (
   SELECT DISTINCT(period_of_service_id)
   FROM per_all_assignments_f
   WHERE assignment_id = p_assignment_id
   AND assignment_type = 'E');