APPS.PAY_NO_HIGH_RATE_TAX SQL Statements

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

Line: 43

 	select 'Y'
 	from PAY_USER_TABLES
 	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO' ;

Line: 48

 	select user_table_id
 	from PAY_USER_TABLES
 	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO';

Line: 53

 	select user_column_id
 	from PAY_USER_COLUMNS
 	where USER_TABLE_ID = l_table_id
 	AND user_column_name = l_freq;

Line: 58

 	select VALUE , user_row_id
 	from pay_user_column_instances_f
 	where user_column_id = l_column_id
 	AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
 	AND user_row_id in (select user_row_id from  pay_user_rows_f where
 			     	user_table_id = l_table_id and to_number(l_ptd_amount) between to_number(row_low_range_or_name) and to_number(row_high_range)
 			     	AND l_date  between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE);

Line: 66

 	select ROW_LOW_RANGE_OR_NAME , ROW_HIGH_RANGE
 	from PAY_USER_ROWS_F
 	where USER_ROW_ID = l_row_id
 	AND l_date BETWEEN EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line: 71

 	select VALUE , user_row_id
 	from pay_user_column_instances_f
 	where user_column_id = l_column_id
 	AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
 	AND user_row_id <> l_high_row_id;

Line: 217

 	select 'Y'
 	from PAY_USER_TABLES
 	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO' ;

Line: 224

 	select user_table_id
 	from PAY_USER_TABLES
 	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO';

Line: 231

 	select user_column_id
 	from PAY_USER_COLUMNS
 	where USER_TABLE_ID = l_table_id
 	AND user_column_name = l_freq;

Line: 238

 	select VALUE , user_row_id
 	from pay_user_column_instances_f
 	where user_column_id = l_column_id
 	AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
 	AND user_row_id in (select user_row_id
			    from  pay_user_rows_f
			    where user_table_id = l_table_id
			    and to_number(l_ptd_amount) between to_number(row_low_range_or_name) and to_number(row_high_range)
 			    and l_date  between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE);

Line: 250

 	select ROW_LOW_RANGE_OR_NAME , ROW_HIGH_RANGE
 	from PAY_USER_ROWS_F
 	where USER_ROW_ID = l_row_id
 	AND l_date BETWEEN EFFECTIVE_START_DATE and EFFECTIVE_END_DATE;

Line: 257

 	select VALUE , user_row_id
 	from pay_user_column_instances_f
 	where user_column_id = l_column_id
 	AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
 	AND user_row_id <> l_high_row_id;

Line: 368

  	select 'Y'
  	from PAY_USER_TABLES
  	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO';

Line: 374

  	select user_table_id
  	from PAY_USER_TABLES
  	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO';

Line: 380

  	select user_column_id
  	from PAY_USER_COLUMNS
  	where USER_TABLE_ID = l_table_id
  	AND user_column_name = l_freq;

Line: 387

  	select value
  	from pay_user_column_instances_f
  	where user_column_id = l_column_id
  	AND user_row_id in (select user_row_id from pay_user_rows_f
  	where user_table_id = l_table_id AND l_date between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
  	AND to_number(l_ptd_amount) between to_number(ROW_LOW_RANGE_OR_NAME) and to_number(ROW_HIGH_RANGE));

Line: 398

  	select value
  	from pay_user_column_instances_f
  	where user_column_id = l_column_id
  	AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
  	AND user_row_id in (select user_row_id from pay_user_rows_f
  	where user_table_id = l_table_id AND l_date between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
  	AND to_number(l_ptd_amount) between to_number(ROW_LOW_RANGE_OR_NAME) and to_number(ROW_HIGH_RANGE));

Line: 479

 	select 'Y'
 	from PAY_USER_TABLES
 	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO';

Line: 484

 	select user_table_id
 	from PAY_USER_TABLES
 	where USER_TABLE_NAME = l_table_name
      and legislation_code = 'NO';

Line: 489

 	select user_column_id
 	from PAY_USER_COLUMNS
 	where USER_TABLE_ID = l_table_id
 	AND user_column_name = l_freq;

Line: 494

 	select VALUE
 	from pay_user_column_instances_f
 	where user_column_id = l_column_id
 	AND l_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
 	AND user_row_id in (select user_row_id from  pay_user_rows_f where
 			     	user_table_id = l_table_id and to_number(l_ptd_amount) between to_number(row_low_range_or_name) and to_number(row_high_range)
 			     	AND l_date  between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE);

Line: 541

	Select Amount1
 	from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF
 	where PRTF.range_table_id = PRF.range_table_id
	and PRTF.range_table_number = TO_NUMBER(l_table_number)
	and PRTF.period_frequency = l_freq
	and PRTF.earnings_type = l_type
	and PRTF.business_group_id = l_bg_id
	and PRTF.legislation_code = 'NO'
	and l_date between PRTF.effective_start_date and PRTF.effective_end_date
	and to_number(l_amount)	between PRF.low_band and PRF.high_band
	and l_date between PRF.effective_start_date and PRF.effective_end_date;

Line: 558

	Select Amount1
 	from PAY_RANGE_TABLES_F PRTF , PAY_RANGES_F PRF
 	where PRTF.range_table_id = PRF.range_table_id
	and PRTF.range_table_number = TO_NUMBER(l_table_number)
	and PRTF.period_frequency = l_freq
	and PRTF.earnings_type = l_type
	and PRTF.business_group_id IS NULL
	and PRTF.legislation_code = 'NO'
	and l_date between PRTF.effective_start_date and PRTF.effective_end_date
	and to_number(l_amount)	between PRF.low_band and PRF.high_band
	and l_date between PRF.effective_start_date and PRF.effective_end_date;

Line: 596

  SELECT ptp.prd_information1
  FROM per_time_periods ptp , pay_payroll_actions ppa
  WHERE ppa.payroll_action_id = l_pact_id
  AND   ppa.action_type in ('Q','R')
  AND   ppa.time_period_id = ptp.time_period_id
  AND   ptp.payroll_id = l_payroll_id;

Line: 718

	SELECT person_id
	FROM per_all_assignments_f paf
	WHERE paf.assignment_id = l_assignment_id
	AND l_date_earned between paf.effective_start_date and paf.effective_end_date;

Line: 724

	SELECT assignment_id
	FROM per_all_assignments_f paf
	WHERE paf.person_id = l_person_id
	AND   primary_flag = 'Y'
	AND l_date between paf.effective_start_date and paf.effective_end_date;

Line: 731

	SELECT screen_entry_value
	FROM pay_element_entry_values_f eev,
	     pay_element_entries_f ee,
	     pay_element_types_f et,
	     pay_input_values_f iv
	WHERE eev.element_entry_id = ee.element_entry_id
	And l_date between eev.effective_start_date and ee.effective_end_date
	And ee.assignment_id = l_assignment_id
	AND l_date between ee.effective_start_date and ee.effective_end_date
	And et.element_name = 'Tax Card'
	And et.legislation_code = 'NO'
	And l_date between et.effective_start_date and et.effective_end_date
	And et.element_type_id = iv.element_type_id
	And iv.name = l_input_name
	And l_date between iv.effective_start_date and iv.effective_end_date
	And eev.input_value_id = iv.input_value_id;

Line: 752

	SELECT full_name , employee_number
	FROM per_all_people_f
	WHERE person_id = l_person_id
	AND l_date_earned between effective_start_date and effective_end_date ;

Line: 759

	SELECT ee.ELEMENT_ENTRY_ID
	FROM pay_element_entries_f ee,
	     pay_element_types_f et
	WHERE et.element_name = 'Tax Card'
	And et.legislation_code = 'NO'
	And l_date between et.effective_start_date and et.effective_end_date
        And et.element_type_id = ee.element_type_id
        AND ee.assignment_id = l_assignment_id
	AND l_date between ee.effective_start_date and ee.effective_end_date ;

Line: 776

    SELECT distinct eev.screen_entry_value Tax_Municipality
    FROM   pay_element_entries_f	pee
          ,pay_element_entry_values_f	eev
          ,pay_input_values_f		piv
          ,pay_element_types_f		pet
          ,pay_payroll_actions		ppa
    WHERE  ppa.payroll_action_id    = pay_act_id
    AND    pee.assignment_id        = p_asg_id
    AND    pet.element_name         = 'Employer Contribution Information'
    AND    pet.legislation_code     = 'NO'
    AND    piv.name                 = 'Tax Municipality'
    AND    pee.element_entry_id     = eev.element_entry_id
    AND    eev.input_value_id + 0   = piv.input_value_id
    AND    piv.element_type_id      = pet.element_type_id
    AND    ppa.effective_date       BETWEEN pee.effective_start_date AND     pee.effective_end_date
    AND    ppa.effective_date       BETWEEN eev.effective_start_date AND     eev.effective_end_date
    AND    ppa.effective_date       BETWEEN piv.effective_start_date AND     piv.effective_end_date
    AND    ppa.effective_date       BETWEEN pet.effective_start_date AND     pet.effective_end_date ;

Line: 799

	SELECT ORG_INFORMATION6   lu_tax_mun
	FROM   pay_assignment_actions	assact ,
	       per_all_assignments_f    paa  ,
	       pay_payroll_actions	ppa ,
	       hr_soft_coding_keyflex   scl ,
	       hr_organization_information hoi
	WHERE  assact.assignment_action_id =  p_assignment_action_id
	AND    ppa.payroll_action_id = assact.payroll_action_id
	AND    paa.assignment_id = assact.assignment_id
	AND    ppa.effective_date BETWEEN paa.effective_start_date AND paa.effective_end_date
	AND    paa.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
	AND    hoi.organization_id = scl.segment2
	AND    hoi.org_information_context = 'NO_LOCAL_UNIT_DETAILS' ;

Line: 968

SELECT ptp.prd_information2
FROM per_time_periods ptp,
  pay_payroll_actions ppa
WHERE ppa.payroll_action_id = l_pact_id
 AND ppa.action_type IN('Q','R')
 AND ppa.time_period_id = ptp.time_period_id
 AND ptp.payroll_id = l_payroll_id ;