APPS.AP_WEB_DB_USER_PREF_PKG SQL Statements

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

Line: 11

  SELECT default_approver_id,
         default_expense_template_id,
         default_purpose,
         NVL(validate_details_flag,'N'), -- should this be N by default?
         NVL(default_foreign_curr_flag,'N'), -- should this be N by default?
         NVL(default_exchange_rate_flag,'N')
  INTO   p_userPrefs_rec.default_approver_id,
	 p_userPrefs_rec.default_expense_template_id,
         p_userPrefs_rec.default_purpose,
         p_userPrefs_rec.validate_details_flag,
         p_userPrefs_rec.default_foreign_curr_flag,
         p_userPrefs_rec.default_exchange_rate_flag
  FROM   ap_web_preferences
  WHERE  employee_id = p_employee_id;

Line: 58

  SELECT ai.numeric_value, ai.period_id
  INTO   p_cumulative_mileage, p_period_id
  FROM   ap_web_employee_info_all ai,
	 ap_pol_schedule_periods ap
  WHERE  ap.policy_id = p_policy_id
  AND    ap.start_date <= p_start_date
  AND    nvl(ap.end_date, p_end_date + 1) >= p_end_date
  AND    ap.schedule_period_id = ai.period_id
  AND    value_type = 'CUM_REIMB_DISTANCE'
  AND    employee_id = p_employee_id;

Line: 74

    SELECT ap.schedule_period_id
    INTO   l_period_id
    FROM   ap_pol_schedule_periods ap
    WHERE  ap.start_date <= p_start_date
    AND    nvl(ap.end_date, p_end_date + 1) >= p_end_date
    AND	   policy_id = p_policy_id;