APPS.PAY_IE_PENSIONS SQL Statements

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

Line: 12

   SELECT DISTINCT floor(months_between(p_date_earned,p.date_of_birth)/12) into l_age
   FROM per_all_people_f p, per_all_assignments_f a
   WHERE a.person_id=p.person_id AND a.assignment_id=p_assgt_id;

Line: 16

     SELECT i.value INTO l_percent
	 FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
	 WHERE t.user_table_name = 'IE PRSA Certificate Rates'
	 AND t.user_table_id=c.user_table_id
	 AND t.user_table_id=r.user_table_id
	 AND i.user_column_id=c.user_column_id
	 AND i.user_row_id=r.user_row_id
     AND c.user_column_name = 'PRSA1'
	 AND l_age BETWEEN r.row_low_range_or_name AND r.row_high_range
	 AND p_date_earned BETWEEN r.effective_start_date AND r.effective_end_date
 	 AND p_date_earned BETWEEN i.effective_start_date AND i.effective_end_date;

Line: 28

    SELECT i.value INTO l_percent
	FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
	WHERE t.user_table_name = 'IE PRSA Certificate Rates'
	AND t.user_table_id=c.user_table_id
	AND t.user_table_id=r.user_table_id
	AND i.user_column_id=c.user_column_id
	AND i.user_row_id=r.user_row_id
    AND c.user_column_name = 'PRSA2'
	AND l_age BETWEEN r.row_low_range_or_name AND r.row_high_range
	AND p_date_earned BETWEEN r.effective_start_date AND r.effective_end_date
    AND p_date_earned BETWEEN i.effective_start_date AND i.effective_end_date;

Line: 49

  SELECT global_value INTO l_amount
  FROM ff_globals_f g
  WHERE g.global_name = 'IE_PENSIONS_EARNINGS_CAP'
  AND p_date_earned BETWEEN g.effective_start_date AND g.effective_end_date;

Line: 68

   SELECT ee_contribution_percent, ee_annual_contribution
   INTO l_percent, l_amount
   FROM pqp_pension_types_f
   WHERE pension_type_id = p_pension_type_id
   AND p_date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 77

   SELECT er_contribution_percent, er_annual_contribution
   INTO l_percent, l_amount
   FROM pqp_pension_types_f
   WHERE pension_type_id = p_pension_type_id
   AND p_date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 97

     SELECT i.value INTO l_percent
	 FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
	 WHERE t.user_table_name = 'IE PRSA Certificate Rates'
	 AND t.user_table_id=c.user_table_id
	 AND t.user_table_id=r.user_table_id
	 AND i.user_column_id=c.user_column_id
	 AND i.user_row_id=r.user_row_id
     AND c.user_column_name = 'PRSA1'
	 AND p_age BETWEEN r.row_low_range_or_name AND r.row_high_range
	 AND p_date_earned BETWEEN r.effective_start_date AND r.effective_end_date
 	 AND p_date_earned BETWEEN i.effective_start_date AND i.effective_end_date;

Line: 109

    SELECT i.value INTO l_percent
	FROM pay_user_tables t, pay_user_columns c, pay_user_rows_f r, pay_user_column_instances_f i
	WHERE t.user_table_name = 'IE PRSA Certificate Rates'
	AND t.user_table_id=c.user_table_id
	AND t.user_table_id=r.user_table_id
	AND i.user_column_id=c.user_column_id
	AND i.user_row_id=r.user_row_id
    AND c.user_column_name = 'PRSA2'
	AND p_age BETWEEN r.row_low_range_or_name AND r.row_high_range
	AND p_date_earned BETWEEN r.effective_start_date AND r.effective_end_date
    AND p_date_earned BETWEEN i.effective_start_date AND i.effective_end_date;